随笔-196  评论-90  文章-8  trackbacks-0
DDL

-- 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 一凡 阅读(158) 评论(0)  编辑  收藏 所属分类: DATABASE

只有注册用户登录后才能发表评论。


网站导航: