Post reply

Script for primary key

  • March 2, 2008 at 10:46 pm

    #179534

    Hi all 🙂

    I am making my database script using script wizard of microsoft sql server 2005.

    I set option Script Primary Key=flase

    Now I run this script on my main server and then export data. Problem is this that how I can set again primary key on sever databse.

    If I set option Script Primary Key=true then my primary key data start from 1,2,3... and data export will not work correctly.

    Hope you people got my problem exactly.

    Suppose I have data in table

    ID Name

    11 Shakti

    12 Rahul

    if Script Primary Key=true then after exporting data will change into

    ID Name

    1 Shakti

    2 Rahul

    if Script Primary Key=false then data will transfer correctly bu how I can set primary key again on ID

    I have 257 tables in my database

    Thanks

    Warm Regards,
    Shakti Singh Dulawat
    Before printing, think about the environment
    Do the impossible, and go home early.

  • March 3, 2008 at 10:30 am

    #784540

    I'm not sure if i understood the problem, but after exporting data, you could always just set the primary key manually...just right click on the column name ...click modify and for that particular column in the properties ection below set it to primary key.

    Hope that helps

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

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