CREATE TABLE 문을 사용하여 새로운 테이블을 생성한다.
CREATE {TABLE | CLASS} <table_name>
[ <subclass_definition> ]
[ ( <column_definition> [,<table_constraint>]... ) ]
[ AUTO_INCREMENT = initial_value ] ]
[ CLASS ATTRIBUTE ( <column_definition_comma_list> ) ]
[ METHOD <method_definition_comma_list> ]
[ FILE <method_file_comma_list> ]
[ INHERIT <resolution_comma_list> ]
[ REUSE_OID ]
<column_definition> ::=
column_name column_type [[ <default_or_shared> ] | [ <column_constraint> ]]...
<default_or_shared> ::=
{SHARED <value_specification> | DEFAULT <value_specification> } |
AUTO_INCREMENT [(seed, increment)]
<column_constraint> ::=
NOT NULL | UNIQUE | PRIMARY KEY | FOREIGN KEY <referential definition>
<table_constraint> ::=
[ CONSTRAINT [ <constraint_name> ] ] UNIQUE [ KEY | INDEX ]( column_name_comma_list ) |
[ { KEY | INDEX } [ <constraint_name> ]( column_name_comma_list ) |
[ PRIMARY KEY ( column_name_comma_list )] |
[ <referential_constraint> ]
<referential_constraint> ::=
FOREIGN KEY [ <foreign_key_name> ]( column_name_comma_list ) <referential definition>
<referential definition> ::=
REFERENCES [ referenced_table_name ] ( column_name_comma_list )
[ <referential_triggered_action> ... ]
<referential_triggered_action> ::=
{ ON UPDATE <referential_action> } |
{ ON DELETE <referential_action> } |
{ ON CACHE OBJECT cache_object_column_name }
<referential_action> ::=
CASCADE | RESTRICT | NO ACTION | SET NULL
<subclass_definition> ::=
{ UNDER | AS SUBCLASS OF } table_name_comma_list
<method_definition> ::=
[ CLASS ] method_name
[ ( [ argument_type_comma_list ] ) ]
[ result_type ]
[ FUNCTION function_name ]
<resolution> ::=
[ CLASS ] { column_name | method_name } OF superclass_name
[ AS alias ]
CREATE TABLE olympic (
host_year INT NOT NULL PRIMARY KEY,
host_nation VARCHAR(40) NOT NULL,
host_city VARCHAR(20) NOT NULL,
opening_date DATE NOT NULL,
closing_date DATE NOT NULL,
mascot VARCHAR(20) ,
slogan VARCHAR(40) ,
introduction VARCHAR(1500)
);