To create a SQL Anywhere 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 permissions, and so on. See PowerDesigner Physical Data Model.
For more information about designing databases and creating a CDM, see the Sybase PowerDesigner documentation at http://infocenter.sybase.com/help/index.jsp.
For more information about database objects such as tables and views, see Working with database objects.
You can also use Sybase Central, Interactive SQL, or the command line to create or initialize a SQL Anywhere database. After creating the database, you can connect to it and add tables and other objects.
Choosing object names
Choosing column data types
Choosing column compression
Create a database (Sybase Central)
Create a database (SQL)
Create a database (command line)
Create a database with a transaction log mirror
Tutorial: Creating a SQL Anywhere database
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|