Post reply

sp_help

  • November 27, 2009 at 11:30 am

    #140218

    I use sp_help frequently to get a list of field names and data types from a table I'm doing selects from. I've never come across this, but I've often wondered what would happen if there were two tables with the same name but different schemas. Since you can't seem to be able to specify the schema name when using this SP. I always get an incorret syntax error message when I do.

    Would there be no way for a user to use this SP on a table that did not have a schema the same as the user's default?

    -Jeff

  • November 28, 2009 at 8:23 am

    #1085096

    sp_help [owner.tablename]

    ---------------------------------------------------------------------------------

  • November 30, 2009 at 10:42 am

    #1085555

    I was sure there had to be a way to do this.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

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