I posted this cod in my SQL and keep getting error: Create Table Specialty ( 

SpecialtyNumber Char(10) Not Null, 

SpecialtyNameChar (50) Not Null, 

CONSTRAINT pk_sn PRIMARY KEY (SpecialtyName), 

CONSTRAINT uq_sn Unique (SpecialtyNumber) 

); 

My  code is: 

Create Table Specialty ( 

SpecialtyNumber Char(10) Not Null, 

SpecialtyNameChar (50) Not Null, 

CONSTRAINT pk_sn PRIMARY KEY (SpecialtyName), 

CONSTRAINT uq_sn Unique (SpecialtyNumber) 

);