The error message basically said that it can't perform the operation because an index was dependent on the field. The table was clear when I tried running the operation.
I actually got around this by dropping the index and then recreating the index after the alter column. Kinda cheesy though.
Hi all,
I'm trying to change the "Allow Nulls" property of a field to NOT NULL using
ALTER TABLE tablename ALTER COLUMN fieldname varchar(7) NOT NULL
But since there's an index that's dependent on the field, it returns with an ERROR. However, when I try to do this manually through...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.