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.
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.