oracle建表、改表(加字段)、添加主键、注释、创建序列--示例

1.建表语法

CREATE TABLE TB_test
(
    id          int            NOT NULL,
    street      varchar2(20)   NULL,
    name        varchar2(255)  NULL,
    preDate     date           NULL,
    description varchar2(2000) NULL,
    makeDate    date           NULL,
    modifyDate  date           NULL,
    operator    varchar2(10)   NULL
);

2.改表(加字段)

ALTER TABLE TB_test ADD source int;
COMMENT ON COLUMN TB_test.source IS '来源';

3.添加主键

alter table TB_test
    add constraint pk_id_TB_test primary key (id);

4.添加注释

---添加表注释：
COMMENT ON table TB_testIS '测试表';
---添加字段注释：
comment on column TB_test.id is '主键';
comment on column TB_test.street is '街道';
comment on column TB_test.name is '名称';
comment on column TB_test.preDate is '时间';
comment on column TB_test.description is '描述';
comment on column TB_test.makeDate is '创建日期';
comment on column TB_test.modifyDate is '修改日期';
comment on column TB_test.operator is '操作人';

5.创建序列

create sequence SEQ_TB_test
    minvalue 1
    maxvalue 999999
    increment by 1
    start with 1;