December 9, 2008 at 8:58 pm
Hi there,
I have a table which has 10 indexes (1 clustered 9 non-clustered) i also have the same table in another DB
i need to copy all the indexes to that table as well.
using GUI i can select the indexes and create a script but i have to do it 1 by 1 (no multiple selection)
i have to do the same thing for 10 other tables. its so painfull to do it 1 by 1
can u help me in getting all the indexes associated with 1 table
Cheers
GB
December 9, 2008 at 9:26 pm
You can select a table and script out everything for that table. Right click the table and select Generate Script.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
December 9, 2008 at 10:07 pm
hi did indexes r not coming part of the script
December 9, 2008 at 10:19 pm
Hi all
i found the trick click on the indexes folder and then keep ur "object explorer details" window open then u can select multiple indexes and generate a script
Cheers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply