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 vote268 views1 answer
Create dump file mysql workbench
SQL
0 vote264 views1 answer
How to reset the database value in SQL server
SQL
-1 vote239 views1 answer
How to use update trigger in sql
SQL
0 vote241 views1 answer
Changer un mot de passe mysql
SQL
-1 vote246 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote256 views1 answer
Mysql count grouped rows
SQL
1 vote258 views2 answers
ImportError: No module named mysql.connector
SQL
2 votes261 views1 answer
Drop all database tables oracle sql developer
SQL
10 votes249 views2 answers
Sql merge statement
SQL
0 vote255 views1 answer
T-sql check if data exists
SQL