Help with Alter Table syntax

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Help with Alter Table syntax

Message

From

03/12/2004 08:53:08

02/12/2004 15:27:00

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Miscellaneous

Thread ID:

00966491

Message ID:

00966658

Views:

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
>