Oracle:添加或刪除表語句

標籤：scott   comm   primary   type   基金   arc   gis   alt   時間   

-- Create table
create table PriOffer_Fund
(
  fundno           varchar2(40) not null,
  fundname         varchar2(200) not null,
  fundshortname    varchar2(100) not null,
  fundbelong       varchar2(40) not null,
  fundregist       varchar2(200) not null,
  builddate        varchar2(10),
  fundtypeo        varchar2(40),
  fundtypet        varchar2(40),
  mainlyinvest     varchar2(40),
  duration         number(18,2),
  fundoverallscope number(18,2),
  cindasum         number(18,2),
  cindaothersum    number(18,2),
  thirdpartysum    number(18,2),
  isoffbalance     varchar2(10),
  inputuser        varchar2(10),
  inputorg         varchar2(10),
  inputdate        varchar2(10),
  inputtime        varchar2(10),
  updateuser       varchar2(10),
  updateorg        varchar2(10),
  updatedate       varchar2(10),
  updatetime       varchar2(20)
)
;
-- Add comments to the columns 
comment on column PriOffer_Fund.fundno
  is ‘基金編號‘;
comment on column PriOffer_Fund.fundname
  is ‘基金名稱‘;
comment on column PriOffer_Fund.fundshortname
  is ‘基金簡稱‘;
comment on column PriOffer_Fund.fundbelong
  is ‘基金歸屬‘;
comment on column PriOffer_Fund.fundregist
  is ‘基金註冊地‘;
comment on column PriOffer_Fund.builddate
  is ‘設立日期‘;
comment on column PriOffer_Fund.fundtypeo
  is ‘基金類型1‘;
comment on column PriOffer_Fund.fundtypet
  is ‘基金類型2
‘;
comment on column PriOffer_Fund.mainlyinvest
  is ‘主要投向‘;
comment on column PriOffer_Fund.duration
  is ‘存續期限‘;
comment on column PriOffer_Fund.fundoverallscope
  is ‘基金設立總規模‘;
comment on column PriOffer_Fund.cindasum
  is ‘信達資產承諾出資‘;
comment on column PriOffer_Fund.cindaothersum
  is ‘集團內其他公司承諾出資‘;
comment on column PriOffer_Fund.thirdpartysum
  is ‘第三方承諾出資‘;
comment on column PriOffer_Fund.isoffbalance
  is ‘是否包含表外項目‘;
comment on column PriOffer_Fund.inputuser
  is ‘登記人‘;
comment on column PriOffer_Fund.inputorg
  is ‘登記機構
‘;
comment on column PriOffer_Fund.inputdate
  is ‘登記日期‘;
comment on column PriOffer_Fund.inputtime
  is ‘登記時間‘;
comment on column PriOffer_Fund.updateuser
  is ‘更新人‘;
comment on column PriOffer_Fund.updateorg
  is ‘更新機構‘;
comment on column PriOffer_Fund.updatedate
  is ‘更新日期‘;
comment on column PriOffer_Fund.updatetime
  is ‘更新時間‘;
-- Create/Recreate primary, unique and foreign key constraints 
alter table PriOffer_Fund
  add constraint PriOffer_Fund primary key (FUNDNO);
  
--2.drop  table 使用者.表明 ； 舉例 ：drop table scott.tableA;

Oracle:添加或刪除表語句