nem.ec

Programming Information Security Recipes Personal Code Snippets

Create a primary key on multiple columns

CREATETABLEPersons ( 
    ID intNOTNULL, 
    LastName varchar(255)NOTNULL, 
    FirstName varchar(255), 
    Age int, 
    CONSTRAINTPK_PersonPRIMARYKEY(ID,LastName) 
);