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.
