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
Which are the db2 tools to protect integrity of the database?
Mention the various locks that are available in db2.
What is the maximum size of a char data type in db2?
How many databases are there?
Mention the downsides of page level lock.
What is ibm db2 database?
What's The Error Code For Unique Index Voilation?
What is the default page size of buffer pools?
When reorg is used?
How can you find out the # of rows updated after an update statement?
What is dbrm? When it will be created?
Are view updateable?
define clustering index.
How can you quickly find out the # of rows updated after an update statement?
What do you mean by rollback?
