I'm attempting to create the following table from SQL exam prep Question 1103229.
3. CREATE TABLE Customer5
4. (Custid int Primary Key,
5. Name varchar(10),
6. City varchar (15) Default 'Atlanta',
**7. State char(2) CHECK IN ('GA','FL','TN'),
8. AccountID int UNIQUE,
9. SalesPerson varchar(15) NOT NULL);
I get the following error message:
**Msg 156, Level 15, State 1, Line 7
Incorrect syntax near the keyword 'IN'.
The code to this table looks good to me. How would an error such as this be trouble shot?