Creating SQL Tables

To create a SQL table:

In the SQL Tables form, select Actions > New and specify the table name
Verify that the schema is dbo.
Indicate whether the table includes a multi-site column.
Save the record.
Click Columns.
In the SQL Columns form, add columns for the new table and define metadata about the columns such as the data type, length, and default value (when applicable to the data type).
Save the columns and return to the SQL Tables form.
Click New Constraint to open the SQL Tables Constraint form and define one or more primary keys or other constraints for the table.

See Specifying Primary Keys and Other Constraints for a Table.
To save the constraint and return to the SQL Tables form, click OK.

After you create tables or columns, you can create IDOs, IDO extension classes, or events that use the tables and columns. You can also filter for a table in the SQL Tables form, and alter the columns and other attributes.

Note: This application requires certain columns on tables that it uses. If you import a table into your database, you can filter for it in the SQL Tables form, and then click Update Current Table to add those required columns.