SQL Drop function

Endurance Man

Im trying to delete a field in a table, i just created the table so i know it exits.

ALTER TABLE Officers
DROP StaffLinkToAct
Go

I get this error:
Server: Msg 3728, Level 16, State 1, Line 4
'StaffLinkToAct' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 4
Could not drop constraint. See previous errors.

Is it trying to tell me this field does not exits? Odd seing as i just created it.

markkilpatrick

try

DROP TABLE StaffLinkToAct;

lynchie

markkilpatrick wrote: »

try

DROP TABLE StaffLinkToAct;

Thats statement is to drop the table. He wants to drop a column.

Try Alter Table Officers Drop column StaffLinkToAct; I know that works in MySQL

Endurance Man

Cheers for the replies lads, that worked a treat lynchie.

markkilpatrick

lynchie wrote: »

Thats statement is to drop the table. He wants to drop a column.

Try Alter Table Officers Drop column StaffLinkToAct; I know that works in MySQL

Should have read it twice before replying.