Newby question: Deleting a field from a table via SQL 1

[Juddy58]

Hi just a quick simple question from a sql server newby, what is the sql to delete a field ("fldProduct") from an existing table ("tblProduct"). I know its something simple eg,using Alter Table. I have done a few searches and can't find what im after. I know how to addnew fields to a table etc.

Thanks
Justin

 

[r937]

did you look here? --

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

hint: DROP COLUMN



r937.com | rudy.ca

 

[Juddy58]

Thanks mate, Thats what im after, and a helpful link.

Justin