Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help Dialogs Create Table

Buy now

Download now

SQL*XL online help

SQL*XL Create Table dialog

Create Table dialog


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.

Create Table Screen Print

Dialog items:

See also:

SQL*XL ribbon in Excel