Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nitesh
yes we can drop any column
ALTER TABLE <TABLENAME> DROP COLUMN <COLUMNNAME>
e.g ALTER TABLE EMP DROP COLUMN NAME
| Is This Answer Correct ? | 20 Yes | 36 No |
Post New Answer View All Answers
How to create db2 table in mainframe?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the difference between cursor stability and repeatable read isolation levels?
What is collection in db2 bind?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How is the value function used?
What is dbrm library?
What is query_cache_limit?
What are the benefits of using the db2 database?
What is db2 connect?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How can you classify the locks in db2?
What is copy pending status in db2?
What is package in cobol db2?
