Within SQL Server there are a number of different types of constraints: CHECK DEFAULT FOREIGN KEY PRIMARY KEY UNIQUE The reference for CREATE TABLE can be found here . Now what’s interesting about constraints is when creating a constraint the name is