Create Table dialog

SQL*XL home

The Create Table dialog can be used to create a new table in the database. The create table dialog works with all databases so a table can be created in any database type. The create table dialog can create the table or return the SQL to create the table if it was started from the SQL editor. In any case the SQL can be viewed and copied.

When the create table dialog is started from the insert multiple rows dialog (tick the create table ) the list of columns is built up automatically from the data in the spreadsheet. The correct data type and minimal settings for size, precision and scale are preset. They are overridable of course.

In the dialog you can add and remove columns and enter the following column details:
column name, data type, size, precision, scale, nullable, primary key constraint, unique key constraint, default value and check constraint.

Dialog items:

• Schema dropdown
• Table editbox
• Columns listview
• Delete button
• Delete all button
• New button
• Show SQL button
• Cancel button
• Create Table button
• Create SQL button

See also:

• Dialogs
• Techniques
• Menu and Toolbar Items
• SQL*XL Home