how to delete a column from a table?

nancy · Joined: 14 Mar 2008 Posts: 15

hi guys,

we can delete a row from a table using delete keyword like

delete from table_name where col_name='c.name'

but how to delete a column from a table after the data entry?????/

if it is possible send me the code ??????

Thanks,
Nancy.

nancy · Joined: 14 Mar 2008 Posts: 15

hi guys,

i have got one code ...... but i am not sure this code will applicable for all databases. check it

ALTER TABLE table_name
DROP COLUMN column_name

Greenrose · Joined: 17 Mar 2008 Posts: 17

hai

i saw msg. yes. the fellow coding is applicable for all database.

ALTER TABLE table_name
DROP COLUMN column_name

regards

Laughing

Greenrose · Joined: 17 Mar 2008 Posts: 17

hai

u've delete the column using this code

ALTER TABLE table_name
DROP COLUMN column_name

u've delete the row using delete command

regards
Laughing

nancy · Joined: 14 Mar 2008 Posts: 15

hi Green Rose,

ya, that code is correct. thanks for your reply.

regards,
nancy.