snipt

Ctrl+h for KB shortcuts

SQL

SQL Create composite primary key (2 or more fields)

/*
	Fields have to be NOT NULL
*/

CREATE TABLE UserGroup
(
  [User_Id] INT NOT NULL,
  [Group_Id] INT NOT NULL

  CONSTRAINT PK_UserGroup PRIMARY KEY NONCLUSTERED ([User_Id], [Group_Id])
)
https://snipt.net/embed/e50b8d716317ebde35c8f359478fb919/
/raw/e50b8d716317ebde35c8f359478fb919/
e50b8d716317ebde35c8f359478fb919
sql
SQL
11
2019-06-18T11:49:49
True
False
False
Sep 16, 2014 at 09:16 AM
/api/public/snipt/136481/
sql-create-composite-primary-key-2-or-more-fields-3bfbd5d5
<table class="highlighttable"><tr><td class="linenos"><div class="linenodiv"><pre><a href="#L-1"> 1</a> <a href="#L-2"> 2</a> <a href="#L-3"> 3</a> <a href="#L-4"> 4</a> <a href="#L-5"> 5</a> <a href="#L-6"> 6</a> <a href="#L-7"> 7</a> <a href="#L-8"> 8</a> <a href="#L-9"> 9</a> <a href="#L-10">10</a> <a href="#L-11">11</a></pre></div></td><td class="code"><div class="highlight"><pre><span></span><span id="L-1"><a name="L-1"></a><span class="cm">/*</span> </span><span id="L-2"><a name="L-2"></a><span class="cm"> Fields have to be NOT NULL</span> </span><span id="L-3"><a name="L-3"></a><span class="cm">*/</span> </span><span id="L-4"><a name="L-4"></a> </span><span id="L-5"><a name="L-5"></a><span class="k">CREATE</span> <span class="k">TABLE</span> <span class="n">UserGroup</span> </span><span id="L-6"><a name="L-6"></a><span class="p">(</span> </span><span id="L-7"><a name="L-7"></a> <span class="p">[</span><span class="n">User_Id</span><span class="p">]</span> <span class="nb">INT</span> <span class="k">NOT</span> <span class="k">NULL</span><span class="p">,</span> </span><span id="L-8"><a name="L-8"></a> <span class="p">[</span><span class="n">Group_Id</span><span class="p">]</span> <span class="nb">INT</span> <span class="k">NOT</span> <span class="k">NULL</span> </span><span id="L-9"><a name="L-9"></a> </span><span id="L-10"><a name="L-10"></a> <span class="k">CONSTRAINT</span> <span class="n">PK_UserGroup</span> <span class="k">PRIMARY</span> <span class="k">KEY</span> <span class="n">NONCLUSTERED</span> <span class="p">([</span><span class="n">User_Id</span><span class="p">],</span> <span class="p">[</span><span class="n">Group_Id</span><span class="p">])</span> </span><span id="L-11"><a name="L-11"></a><span class="p">)</span> </span></pre></div> </td></tr></table>