indexes of all tables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

indexes of all tables

Author

Topic

fmardani
Constraint Violating Yak Guru

433 Posts

Posted - 2005-02-09 : 06:23:40

I would like to get all the indexes on the live tables so that I can run this index script on the uat database which has no indexes on it's tables.
How do I create the indexes which are in a database please?
Thanks

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-02-09 : 07:20:04

In EM > MyDatabase > Generate SQL script

Under General Tab - check All tables
Under Formatting tab - UNCHECK create & drop
Under Options - check script indexes

Then preview and copy to clipboard or save to file

Andy

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2005-02-09 : 15:56:17

SELECT *
FROM SYSINDEXES

HTH

=================================================================
Egotism is the anesthetic that dulls the pain of stupidity. -Frank William Leahy, football coach (1908-1973)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources