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 vote187 views2 answers
Plsql function that return a table
SQL
4 votes180 views2 answers
Oracle default date format
SQL
1 vote278 views1 answer
Oracle see column type
SQL
1 vote173 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
7 votes180 views2 answers
Add column table pl sql
SQL
1 vote172 views1 answer
Can not connect to mysql server
SQL
-2 votes188 views2 answers
Add auto_increment column to existing table mysql
SQL
26 votes187 views2 answers
Mysql workbench download
SQL
0 vote142 views1 answer
Como leer datos de mysql esp32
SQL
0 vote187 views1 answer
Cast float mysql
SQL