Dropping Columns 1

Question

Dropping Columns 1

Steve Jones - SSC Editor

SSC Guru

Points: 738171
More actions
July 25, 2018 at 8:06 pm

#77276

Comments posted to this topic are about the item Dropping Columns 1

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72725 More actions · Answer 1

Nice, easy one, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 2

nice easy question, thanks

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

dstrickrott SSCommitted Points: 1951 More actions · Answer 3

dstrickrott

SSCommitted

Points: 1951

July 26, 2018 at 6:05 pm

#1999181

Nice question. Thanks Steve.

brad.mason5 Hall of Fame Points: 3299 More actions · Answer 4

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.

Dropping Columns 1

Cookies on SQLServerCentral