Tables Wizard (Sybase ASE)

Go Up to Sybase ASE Object Wizards

A table is a column-based arrangement of data in which the content of one column has a bearing on the other column(s). So, for example, a table might have a column for authors, another column for the books each author wrote, and a third for the number of copies each title by a given author sold. The data moves across the columns in rows.

Note: You must have CREATE TABLE permissions to generate a new table.

To create a new table using a wizard

1. Open a creation wizard for a table. For details, see Opening an Object Wizard.
2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
   • Properties panel. For details, see Tables (Sybase ASE) - Properties.
   • Columns panel. For details, see Tables (Sybase ASE) - Columns.
   • Indexes panel. For details, see Tables (Sybase ASE) - Indexes.
   • Constraints panel. For details, see Tables (Sybase ASE) - Constraints.
   • Partitions panel. For details, see Tables (Sybase ASE) - Partition.
   • Permissions panel. For details, see Tables (Sybase ASE) - Permissions.
   • DDL View panel. For details, see Previewing the DDL Generated to Create the New Object.
3. Click Execute button to create the object.

Tables (Sybase ASE) - Properties

When creating or editing a table, this tab/panel lets you work with the following settings:

Setting	Description
Owner	Select the owner of the table.
Name	Provide a name for the table
Segment Name	Specify the segment on which you want to place the table.
Maximum Rows Per Page	Specifying a number allows you to override the default. The default, 0, creates indexes with full pages and non-clustered indexes with full leaf pages. You can change this number at any time.
Reserve Page Gap
Identity Gap	Specify the size of the identity gap for the table.
MRU Replacement Strategy	When enabled, new pages are read into the least recent end of the page chain. When pages reach the most recent end of the chain, the pages are flushed.
Prefetch Strategy	Enabling this feature allows you to fetch as many as eight 2K data pages simultaneously instead of one at a time (the default).
Lock Scheme	Select a locking scheme of ALLPAGES, DATAPAGES, or DATAROWS.
Expected Row Size	If you specified a Lock Scheme of DATAROWS or DATAPAGES, provide an expected row size.

Tables (Sybase ASE) - Columns

For each column in the table, click Add Column to create a column, provide a Name for the column, and provide or select the remaining column attributes.

Use Delete to drop a selected column.

Use the arrow buttons to reposition the columns.

Note: Because the smalldatetime datatype stores dates and time with less precision than the datetime datatype, before outputting you use the CAST or CONVERT functions to convert any boxes with the smalldatetime datatype to either VARCHAR or datetime datatypes.

Tables (Sybase ASE) - Indexes

Click Add to open the Index Wizard. For details, see Indexes Wizard (Sybase ASE).

Tables (Sybase ASE) - Constraints

Selecting a constraint type and clicking Add opens the object wizard for that object type. For details see:

• Primary Keys Wizard (Sybase ASE)
• Unique Keys Wizard (Sybase ASE)
• Foreign Keys Wizard (Sybase ASE)
• Create Synonym

Tables (Sybase ASE) - Partition

Click Add to open the Table Partition Wizard. For details, see Table Partition wizard for Sybase ASE.

Tables (Sybase ASE) - Permissions

Set up the user permissions for this table.

Table Partition wizard for Sybase ASE

See the following topics for information on editors and wizards that let you open the Sybase ASE Table Partition Wizard:

• Tables Wizard (Sybase ASE)
• Tables Editor (Sybase ASE)

Use the following topics as a guide to understanding and setting the options on this wizard:

Step	Settings and Tasks
Properties	Select a Partition Type of ROUNDROBIN, RANGE, HASH, or LIST.
Columns	(Not available for Partition Type of ROUNDROBIN.) For each column, click Insert a new column to create a column, provide a Name for the column, and provide or select the remaining column attributes. Click Delete to drop a selected column. Use the arrow buttons to reposition the columns.
Partition Definition	(Only available with a Partition Type of HASH or ROUNDROBIN.) Take one of the following actions: Select the Number Of Partitions radio box, specify the Number Of Partitions, and for each partition, click the New button and choose a tablespace from the dropdown, or select the By Partition Name radio box and for each partition, click the New button provide a name and then choose a tablespace from the dropdown.
Range Definitions	(Only available with a Partition Type of RANGE.) Click Define a new partition to open a dialog that lets you provide a name, select a segment, and Add the partition definition.
List Definitions	(Only available with a Partition Type of LIST.) Click Define a new partition to open a dialog that lets you provide a name, select a segment, click the New button to add values, and then Add the partition definition.

When finished, click Finish.