SQL Server add index without dropping table
<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>