Import indexes with SQL Server If I have two tables that have identical constraints, datatypes and primary keys is there a way to 'import' the index from one table to another if they're on the same server, but in separate databases?
The only option will be to script out the index and create it on the new table in the other database.