Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Переименование и удаление таблиц в базе данных
- -- https://www.youtube.com/watch?v=VKhLWx7ue6A
- -------------------------------------------
- -- Примеры команд SQL в рамках урока #14
- CREATE TABLE KMV_CUSTOMERS
- (
- customer_id NUMBER,
- customer_name varchar2(20),
- city varchar2(20)
- )
- ;
- ALTER TABLE OLD_TABLE RENAME TO NEW_TABLE;
- ALTER TABLE KMV_CUSTOMERS RENAME TO KMV_CUSTOMERS_NEW;
- SELECT * FROM KMV_CUSTOMERS;
- SELECT * FROM KMV_CUSTOMERS_NEW;
- DROP TABLE TABLE_NAME;
- DROP TABLE KMV_CUSTOMERS_NEW;
- DROP TABLE TABLE_NAME purge;
Add Comment
Please, Sign In to add comment