Post reply

sp_help on every table in a database

  • October 4, 2007 at 9:24 am

    #178009

    I am trying to use sp_MSforeachtable to show what sp_help shows up. I need on every single user table on a database. Can anyone please help me how to try this

    TIA

  • October 4, 2007 at 9:32 am

    #739174

    ishaan99 (10/4/2007)

    I am trying to use sp_MSforeachtable to show what sp_help shows up. I need on every single user table on a database. Can anyone please help me how to try this

    TIA

    sp_MSforeachtable @command1= "sp_help '?'"

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

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

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