Exec sp_help on a table with a schema

Really quick post regarding sp_help and tables in Schemas (not in dbo). Usually when doing a sp_help, you can do something resembling the following :

EXEC sp_help TableName

However, if you try to do the same with a table with a Schema (SomeSchema.TableName) you will get an error “Incorrect syntax near ‘.'”. To execute the sp_help on a table with a schema, simply surround the desired table and schema with single quotes.

EXEC sp_help 'SomeSchema.TableName'

That’s all there is to it.

Jacob Saylor

Software developer in Kentucky

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: