EXEC sp_helpindex on non-dbo schema

Question

EXEC sp_helpindex on non-dbo schema

Welsh Corgi

SSC Guru

Points: 116520
More actions
March 2, 2012 at 8:12 am

#251875

How do you execute the sp_helpindex system stored procedure on a schema other than dbo?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

EXEC sp_helpindex 'schemaname.objectname'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Ant-Green SSC Guru Points: 113565 More actions · Answer 2

Just need to pass in the schema name along with the object name a bit like

sp_helpindex 'ddl.ddlchangelog'

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I did not enclose in quotes.

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/