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 fields in MS SQL 2005

Author  Topic 

d3ng
Yak Posting Veteran

83 Posts

Posted - 2008-06-15 : 21:24:49
Hi experts,

I would like to ask on how to delete fields in SQL 2005 using SQL scripts?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-15 : 23:47:29
Use 'alter table', you can get details in books online.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-16 : 00:42:05
ALTER TABLE tablename DROP COLUMN columnname
Go to Top of Page
   

- Advertisement -