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