Post reply

Dropping Columns 1

  • July 25, 2018 at 8:06 pm

    #77276

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

  • July 25, 2018 at 10:51 pm

    #1999029

    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

    #1999060

    nice easy question, thanks

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

  • July 26, 2018 at 6:05 pm

    #1999181

    Nice question.  Thanks Steve.

  • July 26, 2018 at 8:24 pm

    #1999188

    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 4 (of 4 total)

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