Sets the name of the database. The -n database option must be specified after the database-file, and applies only to that database.

Syntax

{ dbsrv11 | dbeng11 } [ server-options ] database-file -n string ...

Applies to

All operating systems and database servers.

Remarks

Both database servers and databases can be named. Since a database server can load several databases, the database name is used to distinguish the different databases.

By default, the database receives the name of the database file with the path and extension removed. For example, if the database is started on samples-dir\demo.db and no -n option is specified, the name of the database is demo.

Database names cannot:

• begin with white space, single quotes, or double quotes
• end with white space
• contain semicolons
• be longer than 250 bytes

You can only use the database name utility_db to connect to the SQL Anywhere utility database. See Using the utility database.

See also

• Naming the server and the databases
• -n server option

Example

The following example starts the database server with a cache size of 3 MB, loads the database, and names the database test. Since no database server name has been specified, the server takes its name from the first database, so the server's name is also test.

dbsrv11 -c 3MB "c:\mydata.db" -n "test"

dbsrv11 -n SERV c:\mydata.db -n DATA