Creating Tables (Data Definition Guide)

From InterBase
Jump to: navigation, search

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.

Topics

Advance To: