How to drop column, re: constraint 1

[azoe]

I added a column to a table like this:
alter table MyTable
Add ColumnX varchar(12)

Then I tried to delete that column:

alter table MyTable
Drop ColumnX

But it says: 'ColumnX' is not a constraint
Could not drop constraint

This is the first time I have added or tried to delete a column. I had to look up constraint to see what it was. I think it has to do with whether it can be Null or not. It can be. In Help it said something about a constraint name but I don't recall naming anything but the column. So how do I remove that column?

Thank you.

 

[SQLDenis]

alter table MyTable
Drop Column ColumnX

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/