New Table
SQL statements for the generation of new tables are executed quickly and easily with the function New Table ():
 
 
New field  
Remove field  
Remove all fields  
Editor for appending/processing field types  
  • Primary: Selection of fields of the primary key
  • Index: Selection of the fields to be indexed. If the index name is given (below), an index for all selected fields will be specified, otherwise for every selected field an index with the name 'IDX_Fieldname'
  • Null: Column allows NULL values
  • Name: Field name
  • Type: Field type; the field type can be selected via the selection list; with a manual input of the field type, field types yet to be registered in the list are automatically saved
  • Size: Field size
  • Tablename: Name of the table
  • Indexname: Name of the index
After confirmation of the dialogue with OK, here the following SQL statements are returned:

CREATE TABLE customer(
CustNo INTEGER NOT NULL,
Company VARCHAR(30) NOT NULL,
Addr1 VARCHAR(50) NOT NULL,
Addr2 VARCHAR(50) NULL)

ALTER TABLE customer ADD PRIMARY KEY (CustNo)

CREATE INDEX idx_customer ON customer (Company,Addr1)
 
<< Back