title: MySQL INDEX() syntax equivalent in SQL Server
body: <p>I am following a PHP workbook and one of the exercises asks me to create a table with columns using the following MySQL code</p>
  
  <pre><code>CREATE TABLE messages ( 
      message_id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
      parent_id INT UNSIGNED NOT NULL DEFAULT 0, 
      forum_id TINYINT UNSIGNED NOT NULL, 
      user_id MEDIUMINT UNSIGNED NOT NULL, 
      subject VARCHAR(100) NOT NULL,
      body LONGTEXT NOT NULL, 
      date_entered DATETIME NOT NULL, 
      PRIMARY KEY (message_id), 
      INDEX (parent_id), 
      INDEX (forum_id),
      INDEX (user_id),
      INDEX (date_entered) 
  );
  </code></pre>
  
  <p>The problem is at the place I work they use Microsoft SQL Server so the syntax is different. </p>
  
  <p>What is the equivalent SQL Server syntax I can use for </p>
  
  <pre><code>INDEX (parent_id), 
  INDEX (forum_id),
  INDEX (user_id),
  INDEX (date_entered)
  </code></pre>