CREATE TABLE (구문)

설명

테이블 생성을 위해서 CREATE TABLE 구문을 이용한다.

구문

CREATE { CLASS | TABLE } table_name
[ {UNDER | AS SUBCLASS OF } super_class_name [ {, super_class_name }_ ] ]
TABLE ATTRIBUTE
( table_attr_definition_list ) ]
[ ( attr_definition | table_constraint
[ { , attr_definition | table_constraint_definition }_ ] ) ]
[ METHOD method_definition_list ] ]
[ FILE path_name_list ] ]
[ INHERIT resolution_list [ {, resolution_list }_ ] ] [ ; ]
super_class_name :
[ user_name.]classname
table_attr_definition :
attribute_name datatype { [ DEFAULT value ] | [ NOT NULL ] }
attr_definition :
attribute_name datatype [ { SHARED [ value ] | DEFAULT value } ] [AUTO_INCREMENT ...] [ constraints ]
constraints :
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY ...
table_constraint_definition :
[ CONSTRAINT constraint_name ] {[ UNIQUE | PRIMARY KEY | FOREIGN KEY ]}
(attribute_name [{, attribute_name} ...])
method_definition :
[ CLASS ] method_name [ ( [ arg_type_list ] ) ]
[ result_type ] [ FUNCTION method_implementation_name ]
arg_type :
datatype
result_type :
datatype
resolution_list :
attr_mthd_name OF super_class_name [ AS alias ]

예제

다음은 데모로 제공된 올림픽 데이터베이스의 olympic 테이블을 생성하는 예제이다.

 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)
);