![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE8 (Delphi Win64) » SQL Reference » CREATE TABLE Statement |
CREATE TABLE [IF NOT EXISTS] table_reference ( column_name data type [dimensions] [DESCRIPTION column description] [NULLABLE][NOT NULL] [DEFAULT default value] [MIN | MINIMUM minimum value] [MAX | MAXIMUM maximum value] [CHARCASE UPPER | LOWER | NOCHANGE] [COMPRESS 0..9] [, column_name...] [, [CONSTRAINT constraint_name] [UNIQUE] [NOCASE] PRIMARY KEY (column_name [[ASC |ASCENDING] | [DESC | DESCENDING]] [, column_name...]) [COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE]] [NOKEYSTATS] [TEXT INDEX (column_name, [column_name])] [STOP WORDS space-separated list of words] [SPACE CHARS list of characters] [INCLUDE CHARS list of characters] [DESCRIPTION table_description] [INDEX PAGE SIZE index_page_size] [BLOB BLOCK SIZE BLOB_block_size] [LOCALE locale_name | LOCALE CODE locale_code] [ENCRYPTED WITH password] [USER MAJOR VERSION user-defined_major_version] [USER MINOR VERSION user-defined_minor_version] [LAST AUTOINC last_autoinc_value] )
column_name data type [dimensions] [DESCRIPTION column description] [NULLABLE][NOT NULL] [DEFAULT default value] [MIN or MINIMUM minimum value] [MAX or MAXIMUM maximum value] [CHARCASE UPPER | LOWER | NOCHANGE] [COMPRESS 0..9]
DESCRIPTION column description
NULLABLE
NOT NULL
DEFAULT default value
MIN | MINIMUM minimum value
MAX | MAXIMUM maximum value
CHARCASE UPPER | LOWER | NOCHANGE
CREATE TABLE employee ( Last_Name CHAR(20) DESCRIPTION 'Last Name', First_Name CHAR(15) DESCRIPTION 'First Name', Hire_Date DATE DESCRIPTION 'Hire Date' DEFAULT CURRENT_DATE Salary NUMERIC(10,2) DESCRIPTION 'Salary' DEFAULT 0.00, Dept_No SMALLINT DESCRIPTION 'Dept #', PRIMARY KEY (Last_Name, First_Name) )
[, [CONSTRAINT constraint_name] [UNIQUE] [NOCASE] PRIMARY KEY (column_name [[ASC |ASCENDING] | [DESC | DESCENDING]] [, column_name...]) [COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE]] [NOKEYSTATS]
NOCASE
PRIMARY KEY (column_name [[ASC |ASCENDING] | [DESC | DESCENDING]] [, column_name...])
COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE
NOKEYSTATS
CREATE TABLE employee ( Last_Name CHAR(20) DESCRIPTION 'Last Name', First_Name CHAR(15) DESCRIPTION 'First Name', Hire_Date DATE DESCRIPTION 'Hire Date' DEFAULT CURRENT_DATE Salary NUMERIC(10,2) DESCRIPTION 'Salary' DEFAULT 0.00, Dept_No SMALLINT DESCRIPTION 'Dept #', NOCASE PRIMARY KEY (Last_Name, First_Name) COMPRESS FULL )
TEXT INDEX (column_name, [column_name]) STOP WORDS space-separated list of words SPACE CHARS list of characters INCLUDE CHARS list of characters
DESCRIPTION table_description
INDEX PAGE SIZE index_page_size
BLOB BLOCK SIZE BLOB_block_size
LOCALE locale_name | LOCALE CODE locale_code
ENCRYPTED WITH password
USER MAJOR VERSION user-defined_major_version [USER MINOR VERSION user-defined_minor_version]
LAST AUTOINC last_autoinc_value
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |