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