﻿CREATE TABLE Customer1(
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
Code CHAR( 5 ) NOT NULL ,
FirstName VARCHAR( 30 ) NOT NULL ,
Lastname VARCHAR( 50 ) NOT NULL ,
CONSTRAINT IX_Customer_Code UNIQUE NonClustered( Code ) ,
CONSTRAINT CX_Customer_Code CHECK (
Code LIKE '[1-9][0-9][0-9][0-9][0-9]'
)
)
