#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    56
    Rep Power
    13

    Desc Table function on SQLSERVER 2000?


    Is there a build in function or a way by comand line (select statement) to list all of the columns in a table in SQLSERVER??
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    56
    Rep Power
    13
    Never Mind,

    I always seem to answer my own questions.

    For anyone who's wondering the information is in two system tables

    sysobject and syscolumns

    Just create a view using the ID as the link and there you go!
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2001
    Location
    High above the mucky-muck (Columbus, OH)
    Posts
    266
    Rep Power
    13
    Does MS SQL Server 2000 retain the old 'sp_help' stored procedure? It essentially performed the same option but formated it nicely, said the datatype, etc.

    Try sp_help tablename and see if it works.

IMN logo majestic logo threadwatch logo seochat tools logo