Post reply

Altering a Column that has an Index on it

  • April 20, 2006 at 4:48 am

    #113948

    Hi all,

    I seem to be having problems trying to Alter a table column (i'm trying to change its Data Type) in my database table. The column is currently a Primary key and has an Index on it. I am trying to change its Data Type from a TinyInt to an Int.

    I am using the following Syntax:

    ALTER TABLE tbl_SNG_Status

    ALTER COLUMN StatusUID INT IDENTITY(1, 1)

    Hope you can help.

    Thanks

    Tryst

  • April 20, 2006 at 4:55 am

    #633210

    Use "Design Table" in EM.

    Make all desired changes but don't press "Save". Click on "Create Script" and copy it to QA.

    _____________
    Code for TallyGenerator

  • April 20, 2006 at 5:05 am

    #633211

    Hi and thanks for the reply Sergiy.

    When I go into the Design Table screen and change the data type, the Generate Script button is greyed out until I press the Save button...

    Tryst

  • April 20, 2006 at 6:02 am

    #633222

    After getting over the intial shock of seeing Sergiy advising use of EM (until I read on and realized it was only to use it as an aid to create the script)..here's what you do:

    use EM to make the changes and then click on the button on top that says - "Save change script" - this is to the immediate right of the "Table & Index Properties" - this will generate the script for you and you can copy, paste and run it in QA (after cancelling out of EM)







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 3 (of 3 total)

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