sql server

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sonu981
    New Member
    • Mar 2007
    • 1
    #1

    sql server

    how to get tables inforamation through query
    Tags: None
    • Mustaf Kazi
      New Member
      • Jan 2007
      • 5
      #2
      Originally posted by sonu981
      how to get tables inforamation through query


      suppose @@tablename is my table
      to get columns in table then
      select * from information_sch ema.columns where table_name= @@tablename

      ok

        Comment

        • iburyak
          Recognized Expert Top Contributor
          • Nov 2006
          • 1016
          #3
          You can use

          [PHP]sp_help table_name_here[/PHP]

            Comment

            Previous template Next
            Working...