Dropping columns

[NewSQLUser]

Hi,

I was wondering is someone can help me out by providing the SQL syntax or a reference website for dropping a column from a existing table. Thanks.

 

[tlbroadbent]

The best reference is SQL Books Online. (See faq183-689.)

Use the ALTER TABLE command.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_aa-az_3ied.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[NewSQLUser]

Thanks Terry greatly appreciated.