yes we can drop any column ALTER TABLE <TABLENAME> DROP COLUMN <C

can we drop column from a table

Question Posted / nitesh

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

Please Help Members By Posting Answers For Below Questions

Which isolation level provides maximum concurrency?

1088

What is the difference between oracle and db2?

1028

How can you find out the # of rows updated after an update statement?

1050

What is db2 command?

962

List down the data types in the db2 database.

1038

What is the maximum size of varchar data type in db2?

1064

Which command is used to connect to a database in DB2 ? Give the Syntax.

1029

How to find the number of rows in db2 tables?

992

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2166

How do you select a row using indexes in db2?

1072

How can the duplicate values be eliminated from db2 select?

1039

How to access db2 tables in mainframe?

990

How to view db2 table structure?

959

Give the name of some fields form sqlca.

1018

What are the various data types available in db2?

1011