|
create table OAK_LAB_RESULT_PRINT ( TEST_NO VARCHAR2(32) not null, PRINT_INDICATOR NUMBER(2), PRINT_TIME DATE, PRINT_STAFF VARCHAR2(20) ) tablespace TSP_OAK pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited ); -- Add comments to the columns comment on column OAK_LAB_RESULT_PRINT.TEST_NO is '檢驗(yàn)單號(hào)'; comment on column OAK_LAB_RESULT_PRINT.PRINT_INDICATOR is '打印標(biāo)識(shí)'; comment on column OAK_LAB_RESULT_PRINT.PRINT_TIME is '打印時(shí)間（第一次）'; comment on column OAK_LAB_RESULT_PRINT.PRINT_STAFF is '打印者'; -- Create/Recreate primary, unique and foreign key constraints alter table OAK_LAB_RESULT_PRINT add constraint PK_OAK_LAB_RESULT_PRINT primary key (TEST_NO) using index tablespace TSP_OAK pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); |
網(wǎng)站導(dǎo)航
樓主: 人見百態(tài)
[復(fù)制鏈接]
發(fā)表于 2016-11-28 21:22
/1 
znds.com 