一.數(shù)據(jù)定義語(yǔ)言(DDL)
1.使用create語(yǔ)句創(chuàng)建數(shù)據(jù)庫(kù)對(duì)象,包括[緩沖池(Buffer pool), 事件監(jiān)視器(Event monitor), 函數(shù)(Function), 索引(Index), 模式(Schema), 存儲(chǔ)過(guò)程(Stored procedure), 表(Table), 表空間(Table space), 觸發(fā)器(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")
);