Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Delete a entire column in a table

Author  Topic 

sathishkumar.V
Starting Member

1 Post

Posted - 2008-06-29 : 09:37:39
Hi friends,
I need to delete an entire column in a table with the values in it.
Is there query for deleting a particular column in a table after creation.

sathish

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-06-29 : 09:39:23
do you mean to drop the column ?


alter table yourtablename drop column yourcolumnname



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -