oracle创建表、主键创建和获取表描述字段描述
Oracle创建表、主键,创建和获取 表描述字段描述 创建表,并给表和字段加上描述CREATE TABLE MANTIS_CODE(ID VARCHAR2(32) NOT NULL,NAME VARCHAR2(255) NOT NULL);CREATE TABLE MANTIS_CODE_ITEM(CODE_ID VARCHAR2(32) NOT NULL,VALUE VARCHAR2(32) NOT NULL,NAME VARCHAR2(255); .创建主键alter TABLE MANTIS_CODE add constraint PK_MANTIS_CODE primary key (ID) 联合主键alter TABLE MANTIS_CODE add constraint PK_MANTIS_CODE primary key (ID,NAME) 创建表描述COMMENT ON TABLE mantis_code is 代码表 创建字段描述COMMENT ON COLUMN mantis_code.ID is 代码标识 创建外键alter table MANTIS_CODE_ITEM add constraint FK_MANTIS_CODE_ITEM foreign key(CODE_ID) references MANTIS_CODE(ID) 取得表的描述select * from user_tab_comments where comments is not null 取得字段select t.TABLE_NAME,t.COLUMN_NAME,t.DATA_TYPE,t.DATA_LENGTH,t.DATA_PRECISION,t.DATA_SCALE,t.NULLABLE,t.DATA_DEFAULT from user_tab_columns t where t.TABLE_NAME=USER_INFO 取得字段的描述select * from user_col_comments where comments is not null; 取得表的主键select * from user_cons_columns cc,user_constraints cwhere c.constraint_name = cc.constraint_nameand c.constraint_type = Pand cc.table_name = USER_INFO 取得外键select r.CONSTRAINT_NAME,r.TABLE_NAME,r.R_CONSTRAINT_NAME,rc.COLUMN_NAME,pc.COLUMN_NAME as PK_COLUMN_NAME,pc.TABLE_NAME as PK_TABLE_NAMEfrom USER_CONSTRAINTS r,USER_CONS_COLUMNS rc,USER_CONSTRAINTS p,USER_CONS_COLUMNS pcwhere r.CONSTRAINT_TYPE = Rand r.CONSTRAINT_NAME = rc.CONSTRAINT_NAMEand pc.CONSTRAINT_NAME = p.CONSTRAINT_NAMEand p.CONSTRAINT_TYPE = Pand r.R_CONSTRAINT_NAME = p.CONSTRAINT_NAMEand r.TABLE_NAME = USER_ROLE_MAP如果取得数据库表则从ALL_CONSTRAINTS ALL_CONS_COLUMNS中取得你可以通过这个链接引用该篇文章:http:/lianghyan.bokee.com/tb.b?diaryId=18763148