336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
SET UNUSED / DROP UNUSED COLUMNS
|
ALTER TABLE <table_name> SET UNUSED (<column_name>); Or ALTER TABLE <table_name> SET UNUSED COLUMN <column_name>; |
|
ALTER TABLE <table_name> DROP UNUSED COLUMNS; |
* DROP UNUSED COLUMNS : removes from the table all columns currently makred as unused.
- Does not actually remove the target columns.
- Does not restore the disk space used by these columns.
- DROP will be faster than a normal Dropping.
- Related data dictionary view : USER_UNUSED_TABS
'Oracle' 카테고리의 다른 글
| INDEX (0) | 2006.12.03 |
|---|---|
| The SET UNUSED Option (0) | 2006.12.01 |
| ALTER table statement (2) (0) | 2006.12.01 |
| ALTER table statement (2) (0) | 2006.12.01 |
| The ALTER TABLE Statement (0) | 2006.12.01 |