Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create candidate key through Enterprise Server
Message
 
 
À
22/08/2004 20:47:35
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00935389
Message ID:
00935407
Vues:
22
>Thanks, Sergey. Is there a way to do that visually?

Sure. One way:

In Enterprise Manager right click on the table and open Table Designer.
Click on Manage Indexes icon or select it it from the Right-click menu.
On the Properties dialog that opens, click New, give index name or leave default name.
Select fields that you want to include into index one by one in the grid.
Check 'Create UNIQUE' checkbox and close dialog.

Anothjer way:

In Enterprise Manager right click on the table, select All Tasks and Manage Indexes. The rest is similar to the first one but it more like a wizard.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform