Help with Alter Table syntax

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Help with Alter Table syntax

Message

03/12/2004 08:53:08

02/12/2004 15:27:00

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Divers

Thread ID:

00966491

Message ID:

00966658

Vues:

Could I put the constraint the same as the column name?

lcInsertStr = "ALTER TABLE " + lcTableName + " ADD CONSTRAINT Studnt_id_ PRIMARY KEY (Studnt_Id_)"

>Try

lcInsertStr = "ALTER TABLE " + lcTableName + " ADD CONSTRAINT Table_PK PRIMARY KEY (Studnt_Id_)"

HTH
>