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

0 vote95 views1 answer
Change default schema sql server
SQL
0 vote114 views1 answer
000webhost database values insert
SQL
5 votes107 views2 answers
Sql create tabel with primary key auto_increment code
SQL
5 votes116 views2 answers
Sql server check port number
SQL
0 vote101 views1 answer
SQL loop with cursor
SQL
0 vote116 views1 answer
Mysql update even / odd rows
SQL
0 vote114 views1 answer
Consulta alias con inner join
SQL
0 vote110 views1 answer
Assign value to var in SQL
SQL
3 votes121 views3 answers
Mysql get table size
SQL
0 vote111 views1 answer
How to find columns with null values in sql
SQL