Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: 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.
2007-05-03, 4907👍, 0💬
Popular Posts:
What will be printed as the result of the operation below: main() { int x=20,y=35; x=y++ + x++; y= +...
What is Traceability Matrix? Traceability Matrix is one of the document will prepare by QA.To make s...
How many bits are used to represent Unicode, ASCII, UTF-16, and UTF-8 characters? Unicode requires 1...
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statement...
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...