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 vote122 views1 answer
How to select a row in sql
SQL
2 votes127 views1 answer
Postgresql create table as select
SQL
0 vote130 views1 answer
WHERE not regex in SQL
SQL
0 vote106 views2 answers
Get top 1 row of each group
SQL
0 vote106 views1 answer
Metada in sql
SQL
0 vote154 views1 answer
Reindexing all tables sql server
SQL
7 votes199 views1 answer
Oracle alter sequence restart start with
SQL
4 votes111 views1 answer
Check database name postgresql
SQL
0 vote140 views1 answer
Mysql dump with table query
SQL
2 votes123 views1 answer
Sql finding longest and shortest names in a fleld
SQL