[dba-SQLServer]Temporarily Unbinding an Index

Stoker, Kenneth E Kenneth.Stoker at pnl.gov
Wed Feb 26 14:00:56 CST 2003


Everyone,

Can I temporarily unbind an index from a column, modify the column and bind the index back again?  I have a database I am working on and I just want to change the column to Allow Nulls through T-SQL, but it won't let me because it says that the column is being used elsewhere, in an index.

TIA

Ken Stoker
Technology Commercialization
Information Systems Administrator
PH: (509) 375-3758
FAX: (509) 375-6731
E-mail:  Kenneth.Stoker at pnl.gov 





More information about the dba-SQLServer mailing list