<div>
Why don't you try creating the Indexes using Queries(CREATE INDEX) and see if it is allowing?
</div>


Why don't you try creating the Indexes using Queries(CREATE INDEX) and see if it is allowing?

<div>
<blockquote>
For some reason the 'Import' did not preserve any of the indexes set up on the table in Access.
</blockquote>
Import and Export wizard only works with data, so no indexes, triggers, permissions are imported/exported.<br />
You'll need to script your Access table and adapt the script to run in SQL Server.
</div>


> For some reason the 'Import' did not preserve any of the indexes set up on the table in Access.

Import and Export wizard only works with data, so no indexes, triggers, permissions are imported/exported.
You'll need to script your Access table and adapt the script to run in SQL Server.

<div>
<div class="content wysiwyg-content">
I'm pretty new to SQL, using SQL 2014 Developer edition.<br />
<br />
I imported an MS Access table into my SQL DB using the 'SQL Server 2014 Import and Export Data'<br />
<br />
For some reason the 'Import' did not preserve any of the indexes set up on the table in Access.<br />
<br />
I want to re-create the indexes from within SQL Server Manager.<br />
<br />
However, when I right click in the 'Index' option underneath the table name the 'New Index' option is grayed out and cannot be selected.<br />
<br />
On all of the other tables the 'New Index' option is not grayed out. &nbsp;I can select it and build an index on the table.<br />
<br />
Any ideas on what could be causing this issue?
</div>
</div>


I'm pretty new to SQL, using SQL 2014 Developer edition.

I imported an MS Access table into my SQL DB using the 'SQL Server 2014 Import and Export Data'

For some reason the 'Import' did not preserve any of the indexes set up on the table in Access.

I want to re-create the indexes from within SQL Server Manager.

However, when I right click in the 'Index' option underneath the table name the 'New Index' option is grayed out and cannot be selected.

On all of the other tables the 'New Index' option is not grayed out.  I can select it and build an index on the table.

Any ideas on what could be causing this issue?

Not Able To Build Index on imported table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.