达梦数据库的对象创建语句

非空约束	CREATE TABLE TEST_SCHEMA.NOT_Persons(ID int NOT NULL,Name varchar(255) NOT NULL); insert into TEST_SCHEMA.NOT_Persons values(1,'古天乐'); insert into TEST_SCHEMA.NOT_Persons values(1,'冯小刚'); commit
唯一约束	CREATE TABLE TEST_SCHEMA.PK_Persons ( Id_P int, Name varchar(255), Address varchar(255), CONSTRAINT PK_ID_P UNIQUE (Id_P) ); insert into TEST_SCHEMA.PK_Persons(1,'徐帆','黑龙江省佳木斯市'); insert into TEST_SCHEMA.PK_Persons(2,'杨过','辽宁省生沈阳市'); commit
主键约束	CREATE TABLE TEST_SCHEMA.TABLE_PRI ( ID NUMBER ,USERNAME VARCHAR(16), LOCATION VARCHAR(30), CONSTRAINT PK_USERNAME PRIMARY KEY ("USERNAME") ); INSERT INTO  TEST_SCHEMA.TABLE_PRI VALUES (1, '李亚鹏','黑龙江省佳木斯市'); commit
外键约束	CREATE TABLE TEST_SCHEMA.TABLE_FOR ( USERNAME VARCHAR(16), ID_CARD VARCHAR(25), CONSTRAINT FK_USERNAME FOREIGN KEY REFERENCES primary_key(USERNAME) ); INSERT INTO  TEST_SCHEMA.TABLE_FOR VALUES ('李亚鹏','142232199211182197'); commit
check约束	create table TEST_SCHEMA.CHECK