how to drop a column

[ArchaBhandare]

Can anyone Please tell me what is the command to drop a particular column from a table OR alter a table. Does it require that the table has no data while dropping a column ?

[Arun Immanuel]

Try this:

ArchaBhandare wrote:

Can anyone Please tell me what is the command to drop a particular column from a table.

ALTER TABLE tableName DROP COLUMN columnName.

ArchaBhandare wrote:

Does it require that the table has no data while dropping a column ?

No, it can have data...

Regards, Arun Kumar.A

[chand10]

Syntax to DROP a column: ALTER TABLE table_name DROP COLUMN column_name No,U can DROP the Column even if it contains data also.

Cheers Chandu