Enum in SQL Server

USE WorldofWarcraft;

CREATE TABLE [users]
(
   ID INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
   username nvarchar(255),
   password nvarchar(255),
   mail nvarchar (255),
   [rank]  nvarchar (255) NOT NULL CHECK ([rank] IN('Fresh meat', 'Intern','Janitor','Lieutenant','Supreme being')) DEFAULT 'Fresh meat'
);

Source: stackoverflow.com

Similar codes

10 votes296 views2 answers
SQL rounding numbers
SQL
0 vote282 views1 answer
Psql attribute cannot login
SQL
1 vote279 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote275 views1 answer
Mysql default uuid
SQL
0 vote248 views1 answer
Split a string with expression and get the last value of split sql
SQL
3 votes300 views1 answer
Create a table with an id in mysql
SQL
25 votes316 views1 answer
How to update an attribute in MySQL
SQL
0 vote277 views1 answer
Match end of string regex sql
SQL
0 vote293 views1 answer
Repeatable read trong sql server
SQL
0 vote297 views1 answer
Oracle grant create job
SQL