SQL Tables

Use this form, along with the SQL Columns and SQL Tables Constraint forms, to create, modify or delete custom SQL database tables, or to add custom columns to existing tables.

Caution: Do not delete or modify base application tables or columns. Doing so can cause system instability.

For new custom tables, the required system columns such as CreateDate, CreatedBy, etc., are automatically added, and triggers are automatically generated. You can also indicate whether the table includes a multi-site column. Finally, from this form, you can access the Edit Stored Procedure form, which you can use to create an extension to certain stored procedures.

After you create the custom tables or columns, you can create custom IDOs, IDO extension classes, or events that use the tables and columns.