I'm attempting to create the following table from SQL exam prep Question 1103229.
1.USE Demonstration
2.
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?
