saikoneru1997 / Azure_DataFactory

0 stars 0 forks source link

Contraints_in_SQL #14

Closed saikoneru1997 closed 3 weeks ago

saikoneru1997 commented 3 weeks ago

DBMS contraints not null, unique, primarykey, foreign key,check,default,AUTO_INCREMENT, Composite Key Constraint-A primary key that consists of more than one column. CREATE TABLE EmployeeProject ( EmployeeID INT, ProjectID INT, PRIMARY KEY (EmployeeID, ProjectID) ); Combines more than one column to form a primary key.