Tech Talk A software developer on all things tech, and then some


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.

Comments (0) Trackbacks (0)

No comments yet.

Leave a Reply

No trackbacks yet.

%d bloggers like this: