Creating Tables (Data Definition Guide)
Go Up to Working with Tables
You can create tables in the database with the CREATE TABLE
statement. The syntax for CREATE TABLE
is:
CREATE TABLE table [EXTERNAL [FILE] 'filespec'] (<col_def> [, <col_def> | <tconstraint> ...]);
The first argument that you supply to CREATE TABLE
is the table name, which is required, and must be unique among all table and procedure names in the database. You must also supply at least one column definition.
For the complete syntax, see CREATE TABLE
in the “SQL Statement and Function Reference” chapter of the Language Reference.
InterBase automatically imposes the default SQL security scheme on the table. The person who creates the table (the owner), is assigned all privileges for it, including the right to grant privileges to other users, triggers, and stored procedures. For more information on security, see Planning Security.
Metadata name length Database object names, including table, column, and domain names can be up to 68 types in length: 67 bytes plus a NULL terminator.
For a detailed specification of CREATE TABLE
syntax, see the Language Reference.