Solved

More things like SP_HELPTEXT

Posted on 2011-02-15
3
552 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

751 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