Skrevet av Emne: MS SQL Server: describe Table1  (Lest 2345 ganger)

ATC

  • Gjest
MS SQL Server: describe Table1
« på: 07. April 2009, 18:47 pm »
  • [applaud]0
  • [smite]0
  • WHat is the MS SQL Server equivalent of "describe Table1"?



    ATC

    • Gjest
    [Solved] MS SQL Server: describe Table1
    « Svar #1 på: 07. April 2009, 18:47 pm »
  • [applaud]0
  • [smite]0
  • sp_help Table1;

    Note: DESCRIBE is not an ANSI SQL command, but it is implemented by Oracle and MySQL and therefore quite well known.