title: SQL Server add index without dropping table
body: <p>I need to add an index to a table that already has the primary key indexed. The new index will be on another column.</p>
  <p>I don't have enough permissions on this table to select 'Alter' by right clicking and selecting <strong>'Script table as'</strong>.</p>
  <p>Is there any way to add an index to a column without effecting any of the existing data?</p>
  <blockquote>
  <p><strong>myTable</strong>:</p>
  <ul>
  <li>id -- int -----&gt; this is an identity column, set as PK and indexable</li>
  <li>bookid ---&gt; varchar(20)  ----&gt; this is the column that needs index created</li>
  </ul>
  </blockquote>