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 vote131 views1 answer
Google sheets filter rows above current cell
SQL
1 vote132 views1 answer
Mysql Case sum
SQL
24 votes123 views6 answers
Rename a column in sql server
SQL
1 vote139 views1 answer
Oracle sql first day of year
SQL
0 vote123 views1 answer
Cast for print sql
SQL
0 vote151 views1 answer
Sqlite trim
SQL
0 vote120 views1 answer
Sqlite3 now
SQL
0 vote121 views1 answer
Sql server inner join convert collation
SQL
2 votes174 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote143 views1 answer
Postgresql select fast check no rows
SQL