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. This SQL reference is also available in HTML format.
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.
- Defining Columns
- Defining Integrity Constraints on a Table
- Defining a CHECK Constraint
- Using the EXTERNAL FILE Option