Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting a column in sql server
Message
From
11/04/2002 10:51:41
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00643416
Message ID:
00643750
Views:
8
Thank you for your reference Michael.

I care about column order when I review the structure because I like related columns, such as first name and last name, to be close to each other. Also I like the primary key to be the first field.

I am now writing a program to migrate free tables to SQL Server and I would like to add primary keys in the first position after the migration is finished. Since this program is to be run many times at different customer sites I don't want to do it manually.

Alex

TIA,

Alex

>I know of nothing but check here:
>
>http://www.swynk.com/
>
>BTW, why does the column have to be in a specific position. Any SELECT query can put the columns in the order that you need.
>
>-Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform