本文介绍了如何使用SQL语句进行表结构的变更操作，包括添加、重命名和删除列，创建和删除索引等关键步骤。
1. add column
alter table transaction
add
(SERVICE_LEVEL_CODE NUMBER,
CRYPTOGRAPHY_INDEX VARCHAR2(20)
)
2. renmae column
alter table sales rename column order_date to date_of_order;
alter table transaction
add
(SERVICE_LEVEL_CODE NUMBER,
CRYPTOGRAPHY_INDEX VARCHAR2(20)
)
2. renmae column
alter table sales rename column order_date to date_of_order;
3. drop column
alter table
transaction
DROP COLUMN RELATED_REASON_CODE;
4. create index
CREATE INDEX transaction_idx
ON transaction (instructing_bank_code);
5.alter index
ALTER INDEX index_name
RENAME TO new_index_name;
6. drop index
DROP INDEX index_name;
扫一扫
3982
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
