Collections:
ALTER TABLE - Delete a Column in Oracle
How To Delete a Column in an Existing Table in Oracle?
✍: FYIcenter.com
If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script:
SQL> CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE department_id=90; Table created. SQL> SELECT last_name FROM emp_dept_90; LAST_NAME ------------------------- King Kochhar De Haan SQL> ALTER TABLE emp_dept_90 DROP COLUMN last_name; Table altered. SQL> SELECT last_name FROM emp_dept_90; ERROR at line 1: ORA-00904: "LAST_NAME": invalid identifier
As you can see the column "last_name" is gone.
⇒ DROP TABLE Statement in Oracle
⇐ ALTER TABLE - Add a New Column in Oracle
2020-02-20, 1671🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...