<div>
SQL server doesn't support enums directly - at least not like MySQL (that's the only place where I know about enums ...), but you can create a column as text and put a check constraint on it:<br />
<br />
CREATE TABLE SomeTable (<br />
&nbsp; &nbsp; SomeEnumColumn varchar(10) not null<br />
&nbsp; &nbsp; &nbsp; &nbsp; constraint CkSomeEnumColumn check (<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SomeEnumColumn in ('Value1', 'Value2', 'Value3')<br />
&nbsp; &nbsp; &nbsp; &nbsp; )<br />
)<br />
<br />
Hope that helps. If not, please post more specifics about what you are trying to do in the stored proc.
</div>


SQL server doesn't support enums directly - at least not like MySQL (that's the only place where I know about enums ...), but you can create a column as text and put a check constraint on it:

CREATE TABLE SomeTable (
    SomeEnumColumn varchar(10) not null
        constraint CkSomeEnumColumn check (
            SomeEnumColumn in ('Value1', 'Value2', 'Value3')
        )
)

Hope that helps. If not, please post more specifics about what you are trying to do in the stored proc.

<div>
This is one of feasible approach i already know but i don't want to go this way. coz there is an overhead of maintaing a table and insertions for this.
</div>


This is one of feasible approach i already know but i don't want to go this way. coz there is an overhead of maintaing a table and insertions for this.

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp;Can we have enums in sql-server? If not, is there any equivalent of enum in sql server.<br />
I'm working on tsql and need to use enum in a particualar scenario in a stored procedure.<br />
Thanks in Advance
</div>
</div>


Hi,
   Can we have enums in sql-server? If not, is there any equivalent of enum in sql server.
I'm working on tsql and need to use enum in a particualar scenario in a stored procedure.
Thanks in Advance

Enums in Sql-Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.