Need Script to Set Primary Keys on MS SQL Tables

[ken82m]

Okay I have three databases two of which have almost 500 tables. All of which have been setup by an application.

All the tables have a Column called "A4GLIdentity", I need to set this as the primary key in each table.

I can use SQL Manager to export lists of tables for each DB to a text file. So that Makes things a bit easier.

Server in question in MS SQL 2000

Anyone have any tips?

My only alternative is carpal tunnel LOL muttley

Thanks,

Kenny

Edited July 14, 2008 by ken82m

[DaRam]

Not related to AutoIt, you would have had quicker/better responses posting to a SQL centric forum. Anyhoo....

For each of the 500 tables, you need to run

ALTER TABLE <Table_Name> ADD PRIMARY KEY (A4GLIdentity);

This will only work if A4GLIdentity is Set to "NOT NULL" in the table definitions.

More info. here http://msdn.microsoft.com/en-us/library/aa...92(SQL.80).aspx

Okay I have three databases two of which have almost 500 tables. All of which have been setup by an application.

All the tables have a Column called "A4GLIdentity", I need to set this as the primary key in each table.

I can use SQL Manager to export lists of tables for each DB to a text file. So that Makes things a bit easier.

Server in question in MS SQL 2000

Anyone have any tips?

My only alternative is carpal tunnel LOL muttley

Thanks,

Kenny

[ken82m]

Thank you very much Ram! That did it muttley

You saved me alot of time. Your command and a little excel magic and just ran the commands.

I actually did post a message in the MS SQL section on experts-exchange and they couldn't come up with a way for me to change them all.

I knew AutoIT had some limited SQL support so just hoped someone might have something for me

Thanks again,

Kenny