MySQL enum equivalent in MSSQL 2000

What is the equivalent of this MySQL statement in MSSQL 2000?

create table customer
 (cust_id integer IDENTITY (1, 1) not null,
  fed_id varchar(12) not null,
  cust_type_cd enum('I','B') not null,
  address varchar(30),
  city varchar(20),
  state varchar(20),
  postal_code varchar(10),
  constraint pk_customer primary key (cust_id)
 );
sepknowAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree. the clostest is here a CHAR(1) with a check contraint on the column, allowing only I and B as values.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
There is no concept of ENum in sql server (I heard that SQL 2008 has this feature ) .
0
 
CragCommented:
i don't believe such a data type exists in SQL Server. This would be done using a character data type with a check  constraint.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.