Retrieve Index Information For All Tables

By Nicholas Cain, 2013/06/19

This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to keep the information for reference purposes, or to recreate a lost index.

Total article views: 1214 | Views in the last 30 days: 14

FORUM

"/" allowed in VARCHAR Datatype?????

FORUM

Getting Allow Nulls information

How to programatically check the Allow Nulls property of a field

FORUM

SQL Server does not allow remote connections.".

FORUM

Allow SQL user to execute xp_cmdshell.

Only sysadmin role allowed to run xp_cmdshell?

BLOG

Feedback from Connect : Allow Snapshot Backups

I posted a note to allow snapshots to be backed up in SQL Server. The inability to do so, and...

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Retrieve Index Information For All Tables

"/" allowed in VARCHAR Datatype?????

Getting Allow Nulls information

SQL Server does not allow remote connections.".

Allow SQL user to execute xp_cmdshell.

Feedback from Connect : Allow Snapshot Backups

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

You make SSC a better place

Already a member? Jump in: