March 8th, 2002, 01:20 PM
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??
March 8th, 2002, 01:31 PM
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!
March 8th, 2002, 02:43 PM
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.