oracle数据定义语言ddl.pptVIP

定义约束 CREATE TABLE [ schema .] table ( column datatype [DEFAULT expr ] [ column_constraint ], … [ table_constraint ]); CREATE TABLE emp( empno NUMBER(4), ename VARCHAR2(10), … deptno NUMBER(7,2) NOT NULL , CONSTRAINT emp_empno_pk PRIMARY KEY (EMPNO) ); 定义约束 ? 列约束级 ? 表约束级 column [CONSTRAINT constraint_name ] constraint_type , column,... [CONSTRAINT constraint_name ] constraint_type ( column , ...), NOT NULL 约束 ? 确保该列不允许存放空值 EMP EMPNO ENAME JOB ... COMM DEPTNO 7839 KING PRESIDENT 10 7698 BLAKE MANAGER 30 7782 CLARK MANAGER 10 7566 JONES MANAGER 20 ... NOT NULL 约束 ( 该列没有记录为 NUIL