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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Creating Databases » Creating databases in SQL Anywhere


Design considerations

Before creating a database in SQL Anywhere, prepare by defining all the tables it will have (entities), the columns you want in each table (attributes), and the relationship each table has with the other tables (keys and constraints).

Consider constructing a Conceptual Database Model (CDM) for the database. A CDM helps you visualize your database as a map. You can construct the CDM on paper, or use software such as Sybase PowerDesigner. CDM tools help you validate your design as you construct it, and can also help you create the database.

For more information on designing databases, including how to construct a Conceptual Database Model, visit the PowerDesigner documentation at [external link]

For more information about database objects such as tables and views, see Working with database objects.

Choosing object names
Choosing column data types
Choosing whether to compress columns
Choosing constraints