[dba-SQLServer] Table Definition

Will this work for you?

SELECT so.name AS TableName, sc.name AS FieldName, st.name AS Type, 
	sc.Length, sc.Prec, sc.Scale
FROM sysobjects so INNER JOIN syscolumns sc on so.id = sc.id
	INNER JOIN systypes st on sc.xtype = st.xusertype
WHERE so.name = 'mytablename'

Ken

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Joseph
O'Connell
Sent: Friday, August 27, 2004 9:33 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Table Definition

In an Access application, I can use the Documenter tool to generate a report
of table definitions.

Is there an equivalent tool in SQL Server that will easily create a report
showing the Name, Data Type and Size of the fields in a selected table?

Joe O'Connell



_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com