Avatar of mlcktmguy
Flag for United States of America

asked on 

Not Able To Build Index on imported table

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?
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon