-- Create sequence
create sequence SEQ_TAB_900
minvalue 1
maxvalue 999999999999999999
start with 21
increment by 1
cache 20;
-- Create table
create table TAB_900
(
ID NUMBER not null,
MOBILE VARCHAR2(2),
INSDATE DATE,
constraint pk_tab_900 primary key (ID),
constraint fk_tab_900 foreign key (ID) references tab_xxx(id)
)
-- Create/Recreate primary, unique and foreign key constraints
alter table TAB_900
add constraint PK_TAB_900 primary key (ID);
posted on 2007-04-13 17:22
一凡 閱讀(222)
評論(0) 編輯 收藏 所屬分類:
DATABASE