CREATE TABLE dbo.myTable ( ID int NOT NULL, Name char(23) NULL, DOB datetime NULL, CONSTRAINT PK_myTable PRIMARY KEY (ID) )