[dba-SQLServer] Table Definition

Thank you

Joe

-----Original Message-----
From: Ken Stoker <kens.programming at verizon.net>
To: 'Joseph O'Connell' <joconnell at indy.rr.com>;
dba-sqlserver at databaseadvisors.com <dba-sqlserver at databaseadvisors.com>
Date: Friday, August 27, 2004 1:04 PM
Subject: RE: [dba-SQLServer] Table Definition


|I have always copied the results out to Excel and worked with it from
there.
|The column names aren't included in the copy/paste, so you will need to put
|those in if you need them.
|
|One other thing, the query I provided doesn't return fields with user
|defined types.  I did some more playing around and the best way is to
|replace sc.xtype = st.xusertype with sc.xusertype = st.xusertype.
|
|Ken
|
|-----Original Message-----
|From: Joseph O'Connell [mailto:joconnell at indy.rr.com]
|Sent: Friday, August 27, 2004 10:43 AM
|To: dba-sqlserver at databaseadvisors.com; kens.programming at verizon.net
|Subject: Re: [dba-SQLServer] Table Definition
|
|Ken,
|
|Thank you for your prompt reply.  This query does give me the information
|that I need.
|
|Is there an easy way to print the results of the query?
|
|Joe O'Connell
|
|-----Original Message-----
|From: Ken Stoker <kens.programming at verizon.net>
|To: dba-sqlserver at databaseadvisors.com <dba-sqlserver at databaseadvisors.com>
|Date: Friday, August 27, 2004 12:10 PM
|Subject: RE: [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
||
||_______________________________________________
||dba-SQLServer mailing list
||dba-SQLServer at databaseadvisors.com
||http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
||http://www.databaseadvisors.com
||
|
|