error deletinh column

[SelbyGlenn]

Hi there,

I am trying to delete a column at the end of a table but it's returning an error.

I am typing: ALTER TABLE t1 DROP c12

but it is returning the error:

'c12' is not a contraint. Could not drop constraint.

Any ideas how I can delete this column?

Thanks in advance,

Glenn
BEng MCSE CCA

 

[SQLDenis]

DROP COLUMN!!!

ALTER TABLE t1 DROP COLUMN c12

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/