Transact-SQL: ottenere nome, tipo e lunghezza delle colonne di una tabella

CREATE TABLE test (id INT, c1 VARCHAR(10), c2 money, c3 datetime)
 
/* SQL SERVER 2000 */
SELECT syscolumns.name, systypes.name, syscolumns.LENGTH
  FROM syscolumns JOIN systypes ON syscolumns.xusertype = systypes.xusertype
 WHERE id = (SELECT id FROM sysobjects WHERE name = 'test')
 
/* SQL SERVER 2005 2008 */
SELECT sys.COLUMNS.name, sys.types.name, sys.COLUMNS.max_length
  FROM sys.COLUMNS JOIN sys.types
       ON sys.COLUMNS.user_type_id = sys.types.user_type_id
 WHERE object_id = (SELECT object_id FROM sys.objects WHERE name = 'test')