Creating a Table

Create and define properties for SQL Anywhere, ASE, and Sybase IQ database tables and ASE temporary tables.

1. Right-click the Tables folder and select New > Table.
2. (Optional) Select a different schema object Owner.
3. Enter a Table Name to identify the table.
4. Enter the column information.

   Field	Description
   Primary Key	Select the check box to define the primary key.
   Column Name	Enter a name for the column.
   Datatype	Enter the datatype associated with the column.
   Nullable	Indicate that the column can be NULL.
   Default	View the column default value. This is a read-only column. When you double-click the cell, a Browse button appears. You can click Browse to open the Column Default Value dialog.
   Rule Binding (ASE only)	Specify a rule to bind the column to by selecting a rule from the drop-down menu.
   Identity (ASE only)	Make this column an IDENTITY column. ASE automatically generates a value for this row that uniquely identifies the row within the table.
   Unique	Indicate that the value in the column must be unique.
   Check Constraint (ASE only)	Click ... to open the Define Column Check Constraint wizard.
   IQ Unique (Sybase IQ only)	Define the cardinality of the column. This column is used to optimize the indexes internally. Specify the IQ Unique constraint if the expected number of unique values is less than or equal to 65536. The default is 0.
   Comment (SQL Anywhere, Sybase IQ only)	Enter additional comments about the column.

5. Click Next.
   • (Optional) If creating an ASE table, define the physical storage, cache strategy, and locking strategy.
   • (Optional) If creating a SQL Anywhere or Sybase IQ table, define the storage and primary key options.
6. Click Next and specify save and execution properties.

   Field	Description
   Generate Script	Generate a SQL file for the table.
   Enter or Select the Parent Folder	Specify an existing project or create a new project in which to save the SQL file.
   File Name	Enter the file name in which to store the SQL code.
   Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must complete execution of the SQL file later to create the table.
   Open in Editor After Creation	Create the table and open it in the Table Schema Editor.

7. Click Finish.
8. Review the status in SQL Results view.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com