title: Can I have a custom enumeration data-type in Sql Server?
body: <p>In my sql code i'm passing around a bunch of magic numbers :-</p>
  <pre><code>AnimalType TINYINT
  
  /*
    AnimalType can be one of the following :-
    1. Cat
    2. Dog
    3. Bird
   ....
  */
  </code></pre>
  <p>Is there anyway i could make this a custom type / enumeration.
  eg.</p>
  <pre><code>AnimalType ANIMAL
  </code></pre>
  <p>and it's constrained to contain a number between 1 &lt;-&gt; whatever (eg. 3 in my example above).</p>
  <p>or constrained to strings. eg. AnimalType = 'Cat' .. etc ?</p>
  <p>Cheers!</p>
  <h3>Edit</h3>
  <p>I know what LookUp tables are. This is not for a lookup table, but for some data passed to a number of stored procedures. Instead of passing in <em>Magic Numbers</em>, I wish to pass in an enumeration OR at least some contrained number (eg. numbers 1&lt;-&gt;5), etc...</p>