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: 16

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: 16

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.

jaikanth123 · Guest

You can delete a column using the DROP COLUMN clause of the ALTER TABLE statement.

Dropping a column deletes that column from the table definition. If CASCADE is specified, any views, indexes, and constraints dependent on that column will also be dropped. If RESTRICT is specified, and any views, indexes, or constraints are dependent on the column, the column will not be dropped and SQLCODE of -196 will be issued.

nicole61 · Joined: 05 Aug 2010 Posts: 1

Hi
This is Nicole Anderson and I've read your post Nancy.
Select the column which you want to delete and then click delete button.
The selected column will be deleted .

roserobin · Joined: 20 Aug 2010 Posts: 4

There are Three Option You can use any one of them like You can use DROP,DELETE and TRUNCATE.It Depend on You How You want to Delete that Column form the both table like your Original table or from the Master table.