一.数据定义语言(DDL)
1.使用create语句创建数据库对象,包括[缓冲池(Buffer pool), 事件监视器(Event monitor), 函数(Function), 索引(Index), 模式(Schema), 存储过程(Stored procedure), 表(Table), 表空间(Table space), 触发器(Trigger), 视图(View)], 例如:
CREATE TABLE "T_CI_YCLLRDZ"
(
"FD_YCLLRDZ_ID" CHAR(35) NOT NULL,
"FD_CIYGBH" CHARACTER(20),
"FD_CJYGMC" CHARACTER(50),
"FD_WZYGBH" CHARACTER(20),
"FD_WZYGMC" CHARACTER(50),
CONSTRAINT "P_KEY_1" PRIMARY KEY ("FD_YCLLRDZ_ID")
);