July 25, 2018 at 8:06 pm
Comments posted to this topic are about the item Dropping Columns 1
July 25, 2018 at 10:51 pm
Nice, easy one, thanks Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 26, 2018 at 6:21 am
nice easy question, thanks
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
July 26, 2018 at 6:05 pm
Nice question. Thanks Steve.
July 26, 2018 at 8:24 pm
I was not sure if SQL would give just first index it found or not. But kind of cool it did display the additional index I added with CustomerName.
Msg 5074, Level 16, State 1, Line 16
The index 'PurchaseOrderNDX_CustomerName' is dependent on column 'CustomerName'.
Msg 5074, Level 16, State 1, Line 16
The index 'PurchaseOrderNDX_CustomerName_PONumber' is dependent on column 'CustomerName'.
Msg 4922, Level 16, State 9, Line 16
ALTER TABLE DROP COLUMN CustomerName failed because one or more objects access this column.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy