DESCRIBE tblName?

• apasetti

  Grasshopper

  Points: 19

  More actions

  November 14, 2003 at 1:25 pm

  #101756

  The DESCRIBE syntax does not appear to be supported in sql server 2000. I'm thinking that my host does not support the methods needed to use this function.

  Perhaps someone can suggest an alternative. Your advice will be greatly appreciated.

  Thanks,

  Andrew Pasetti

• mngong

  SSCertifiable

  Points: 6167

  More actions

  November 14, 2003 at 1:43 pm

  #482130

  Try sp_help "table_name"

  Mike

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 17, 2003 at 3:42 am

  #482175

  There is a DESCRIBE statement in SQL Server, but I assume you're more after the MySQL DESCRIBE statement. Like Mike suggested, use sp_help.

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]