The query as Follows:
ALTER TABLE TableName ADD CONSTRAINT pk_employee PRIMARY KEY (EmployeeId)
Here
pk_employee - constraint Name
EmployeeId -ColumnName of the Table
While adding the constraints to the before Existing table..that column name set to notNull(it must)
ALTER TABLE TableName ADD CONSTRAINT pk_employee PRIMARY KEY (EmployeeId)
Here
pk_employee - constraint Name
EmployeeId -ColumnName of the Table
While adding the constraints to the before Existing table..that column name set to notNull(it must)
No comments:
Post a Comment