Solved

More things like SP_HELPTEXT

Posted on 2011-02-15
3
549 Views
Last Modified: 2012-05-11
I used SP_HELPTEXT to return stored procedure scripts...

Is there a way in which I can quickly return INDEX definition scripts?
0
Comment
Question by:Mr_Shaw
  • 2
3 Comments
 
LVL 8

Accepted Solution

by:
rushShah earned 500 total points
ID: 34895997
try this.


EXEC sp_helpindex 'tableName'

Open in new window

0
 
LVL 8

Assisted Solution

by:rushShah
rushShah earned 500 total points
ID: 34896008
for ex.


USE AdventureWorks;
GO
EXEC sp_helpindex 'Person.Contact'
GO

Open in new window

0
 

Author Closing Comment

by:Mr_Shaw
ID: 34896557
thanks..
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question