Post reply

only works for master DB

  • December 2, 2008 at 12:02 am

    #124704

    Dear all

    "sp_help tablename"

    tell us the design of table.

    But it only works for master DB.

    Wats the commnd to see design of table of other DB's.

    Thanx

    Thanks

  • December 2, 2008 at 12:25 am

    #906052

    guptaajay1985 (12/2/2008)

    Dear all

    "sp_help tablename"

    tell us the design of table.

    But it only works for master DB.

    Wats the commnd to see design of table of other DB's.

    Thanx

    use can change the database and then apply this command.

    Eg:

    use Northwind

    go

    sp_help customers

    go

  • December 2, 2008 at 12:50 am

    #906056

    It is not only for master DB.. you can call that sp in any of the database.

    Also you can use the shortcut ALT+F1 to view the table design.

    You can do this by ... type the tablename.. select it and press ALT+F1.

    You can call sp_help and sp_helptext in any of the database. These are system procedures can be called and executed from any database.

  • December 2, 2008 at 1:37 am

    #906070

    Thanku 2 much

    Thanks

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

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