title: T-SQL create table and index in one query
body: <p>Is it possible to create indexes(no foreign keys and not unique) and table( not a table variable ) with just one SQL statement like this. </p>
  
  <pre><code>CREATE TABLE tabind
  (
      id          int             identity(1,1) primary key   ,
      birthday    datetime        default getdate()           ,
      some_id     int             INDEX index_name, /*this line causes a sql server error*/
      name        nvarchar(100)
  );
  </code></pre>
  
  <p>In fact the equivalent of this statements:</p>
  
  <pre><code>CREATE TABLE tabind
  (
      id          int             identity(1,1) primary key   ,
      birthday    datetime        default getdate()           ,
      some_id int             ,
      name        nvarchar(100)
  );
  
  create index idx_tabind on tabind(some_id);
  </code></pre>
  
  <p><strong>My SQL Server Version is 2012.</strong></p>
  
  <p>Thanks.</p>