select * from user_indexes where table_name=‘INSX_RESOURCE_SHARE_REL_H’ ;–查索引
create index INSX_RES_SHARE_REL_HSUBUSERID on INSX_RESOURCE_SHARE_REL_H (SUB_USER_ID);–建索引
alter table party.cust_students_shen add parents_phone varchar(30);–表增加字段(可空)
alter table party.INSX_MOSAO_GL_INFO modify remark VARCHAR2(20)not null;–表字段变不可空
alter table party.INSX_MOSAO_GL_INFO modify remark VARCHAR2(30)null;–表字段变可空
ALTER TABLE party.INSX_MOSAO_GL_INFO DROP COLUMN name;删除表字段
select * from user_sequences where sequence_name like ‘’;查序列
select seq_xx.nextval from dual;
create sequence seq_xx --创建序列名称
increment by 1 --增长幅度
start with 1 --初始值
maxvalue 9999999999999999; --最大值
RODP SEQUENCE seq_xx;删除序列
ALTER TABLE test_tab DELETE PRIMARY KEY 删除主键
ALTER TABLE test_tab ADD PRIMARY KEY(id);增加主键