• Schema
  • Create Schema
  • Drop Schema
• Table
  • Create Table
  • Truncate Table
  • Drop Table
  • Column
    • Add Column
    • Drop Column
• View
  • Create View
  • Drop View
• Index
  • Create Index
  • Drop Index
• Constraint
  • Create Primary Key
  • Create Foreign Key
  • Create Check Constraint
  • Create Unique Constraint
  • Drop Primary Key
  • Drop Foreign Key
  • Drop Check Constraint
  • Drop Unique Constraint
• Procedure
  • Create Procedure
  • Drop Procedure

Schema

Create Schema

FrontBase allows to create a new schema. After entering the schema name, DtSQL can generate and execute the SQL to create the new schema.

Sample : CREATE SCHEMA "TEST_SCHEMA"

Drop Schema

FrontBase allows to drop an existing schema. After entering the schema name, DtSQL can generate and execute the SQL to drop the schema.

Sample : DROP SCHEMA "TEST_SCHEMA" RESTRICT

Table

Create Table

FrontBase allows to create a new table. After entering the table name and column information, DtSQL can generate and execute the SQL to create the table.

• Column Name
• Column Type
• Length/Precesion
• Scale (decimal)
• Default Value
• Nullable
• Primary Key
• Unique

Sample :
CREATE TABLE "TEST_SCHEMA"."TEST_TABLE" (
a longint DEFAULT 1 NOT NULL ,
b character ( 12 ) DEFAULT 'abc' NOT NULL ,
c decimal ( 12, 2 ) ,

PRIMARY KEY ( a, b ),
UNIQUE ( b,c )
)

Truncate Table

FrontBase does not allows to truncate an table and deleting table is used instead. After entering the table name, DtSQL can delete all data in the table.

Sample : DELETE FROM "TEST_SCHEMA"."TEST_TABLE"

Drop Table

FrontBase allows to drop an existing table. After entering the table name, DtSQL can generate and execute the SQL to drop the table.

Sample : DROP TABLE "TEST_SCHEMA"."TEST_TABLE" RESTRICT

Column

Add Column

FrontBase allows to add a new column to an existing table. After selecting the table and entering column information, DtSQL can generate and execute the SQL to add the new column to the table.

• Column Name
• Column Type
• Length/Precesion
• Scale (decimal)
• Default Value
• Nullable

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
ADD
d varchar(20) DEFAULT 'def' NOT NULL

Drop Column

FrontBase allows to delete an existing column. After selecting the column, DtSQL can generate and execute the SQL to delete the column.

Sample :
ALTER TABLE TEST_SCHEMA.TEST_TABLE
DROP COLUMN F RESTRICT

View

Create View

FrontBase allows to create a new view. After entering the view name and select SQL, DtSQL can generate and execute the SQL to create the view.

Sample :
CREATE VIEW "TEST_SCHEMA"."TEST_VIEW"
AS
SELECT * FROM "TEST_SCHEMA"."TEST_TABLE"

Drop View

FrontBase allows to drop an existing view. After selecting the view name, DtSQL can generate and execute the SQL to delete the view.

Sample : DROP VIEW "TEST_SCHEMA"."TEST_VIEW" RESTRICT

Index

Create Index

FrontBase allows to create a new index. After selecting the table columns and entering the view name, DtSQL can generate and execute the SQL to create the index.

Sample :
CREATE UNIQUE INDEX "TEST_SCHEMA"."TEST_INDEX"
ON "TEST_SCHEMA"."TEST_TABLE" ( A, B, C )

Drop Index

FrontBase allows to drop an existing index. After selecting the index name, DtSQL can generate and execute the SQL to delete the index.

Sample : DROP INDEX "TEST_SCHEMA"."TEST_INDEX"

Constraint

Create Primary Key

FrontBase allows to create a primary key for a table. After selecting the table columns, DtSQL can generate and execute the SQL to create the primary key.

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
ADD
PRIMARY KEY ( B, C )

Create Foreign Key

FrontBase allows to create a foreign key for a table to reference to another table. After selecting the table columns and referenced table columns, DtSQL can generate and execute the SQL to create the foreign key.

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
ADD
FOREIGN KEY ( A, C )
REFERENCES TEST_SCHEMA.TEST_TB (B, A )

Create Check Constraint

FrontBase allows to create a check constraint for a table column. After entering the check constraint name and check action, DtSQL can generate and execute the SQL to create the check constraint.

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
ADD CONSTRAINT TEST_CHECK
CHECK ( C > 10 )

Create Unique Constraint

FrontBase allows to create an unique constraint for a table columns. After entering the unique constraint name and selecting table columns, DtSQL can generate and execute the SQL to create the unique constraint.

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
ADD CONSTRAINT TEST_UNIQUE
UNIQUE ( B, C )

Drop Primary Key

FrontBase allows to drop an existing primary key. After selecting the primary key, DtSQL can generate and execute the SQL to delete the primary key.

Sample : ALTER TABLE TEST_SCHEMA.TEST_TABLE DROP CONSTRAINT _C46 RESTRICT

Drop Foreign Key

FrontBase allows to drop an existing foreign key. After selecting the foreign key, DtSQL can generate and execute the SQL to delete the foreign key.

Sample : ALTER TABLE TEST_SCHEMA.TEST_TABLE DROP CONSTRAINT _C47 RESTRICT

Drop Check Constraint

FrontBase allows to drop an existing check constraint. After selecting the check constraint, DtSQL can generate and execute the SQL to delete the check constraint.

Sample : ALTER TABLE TEST_SCHEMA.TEST_TABLE DROP CONSTRAINT TEST_CHECK RESTRICT

Drop Unique Constraint

FrontBase allows to drop an existing unique constraint. After selecting the unique constraint, DtSQL can generate and execute the SQL to delete the unique constraint.

Sample :
ALTER TABLE
TEST_SCHEMA.TEST_TABLE
DROP CONSTRAINT TEST_UNIQUE RESTRICT

Procedure

Create Procedure

FrontBase allows to create procedures. After entering the procedure name, parameter names and procedure body, DtSQL can generate and execute the SQL to create the procedure.

Sample :
CREATE PROCEDURE TEST_SCHEMA.TEST_PROC
( IN PARAM1 character(20), INOUT PARAM2 integer, OUT PARAM3 TIMESTAMP)
BEGIN
SELECT COUNT(*) FROM "INFORMATION_SCHEMA"."TABLES";
END

Drop Procedure

FrontBase allows to drop an existing procedure. After selecting the procedure, DtSQL can generate and execute the SQL to delete the procedure.

Sample : DROP PROCEDURE "TEST_SCHEMA"."TEST_PROC" RESTRICT