一.數據定義語言(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")
);