Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting a column in sql server
Message
De
11/04/2002 10:51:41
 
 
À
10/04/2002 17:56:28
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Divers
Thread ID:
00643416
Message ID:
00643750
Vues:
9
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform