Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types


Database creation

To create a database, you first define the tables it will have (entities), the columns in each table (attributes), and the relationships between tables (keys and constraints).

It is recommended that you create a Conceptual Database Model (CDM) for your new database. You can use CDM applications such as Sybase PowerDesigner to create and validate your database design. These tools construct SQL statements that are submitted to the database server, typically through its ODBC interface. If you are using one of these tools, you do not need to construct SQL statements to create tables, assign privileges, and so on.

For more information about designing databases and creating a CDM, see the Sybase PowerDesigner documentation at [external link]

You can also use Sybase Central, Interactive SQL, or the command line to create or initialize a database. After creating the database, you can connect to it and add tables and other objects.

 Transaction log
 Database file compatibility
 See also

Object name considerations
Column data type considerations
Column compression considerations
Constraint considerations
Creating a database (Sybase Central)
Creating a database (dbinit utility)