Oracle:添加或删除表语句
来源:互联网 发布:淘宝买零食的店铺 编辑:程序博客网 时间:2024/04/30 13:58
-- 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;
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;
阅读全文
0 0
- Oracle:添加或删除表语句
- Oracle批量生成删除表语句
- SQL删除表语句
- 数据库删除表语句
- JBPM 删除表语句
- oracle 关于表语句
- oracle建表语句
- 修改oracle表语句
- Oracle建表语句
- oracle解锁表语句
- oracle建表语句
- Oracle建表语句
- oracle建表语句
- oracle 标准建表语句
- Oracle 基本建表语句
- Oracle 基本建表语句
- Oracle 基本建表语句
- oracle检查锁表语句
- 公开课总结发布《MySQL DBA快速入门PostgreSQL》
- MySQL 5.7下InnoDB对COUNT(*)的优化
- PC服务器硬盘故障处理
- 改名这件事
- 【深度总结】服务器硬件管理
- Oracle:添加或删除表语句
- 【干货】分享总结:MySQL数据一致性
- hadoop在虚拟机中的配置
- 深度解析:持续交付将如何拯救IT运维?
- 毋庸置疑,知数堂确实靠谱
- 票选出MySQL新版本中您最期待新功能
- MySQL?PostgreSQL?又开撕了...
- (附音视频、PPT地址)《DBA神技之SQL Review》分享总结
- MySQL 8.0产品发展讨论会,您的建议很重要