you can get a recordset of tables and their respective columns in SQL server
by running:
SELECT dbo.sysobjects.name AS tablenames, dbo.syscolumns.name AS
columnnames, dbo.sysobjects.id
FROM dbo.syscolumns INNER JOIN
dbo.sysobjects ON dbo.syscolumns.id = dbo.sysobjects.id
WHERE (dbo.sysobjects.xtype = 'U')
ORDER BY dbo.sysobjects.name DESC
is this what you meant?
> -----Original Message-----
> From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED]]
> Sent: 18 December 2002 16:51
> To: '[EMAIL PROTECTED]'
> Subject: [ cf-dev ] Help - SQL Table field diagramming
>
>
> Hi all you Smart People!!! (OK, yes that was a suck-up
> opening line!!!)
>
> I have been requested to show all the database fields as a
> spreadsheet or
> access database tables for my telemedicine system. When I
> try to export
> tables as a list, I get ALL the data within the tables, not
> just the fields
> being queried. When I try to diagram, and eventually do an Excel
> spreadsheet showing sub-databases and fields, the Query
> Analyzer basically
> blows up and all I get is a fat gray line (database too big?)
>
> Anyway, any ideas on how to do this painlessly and
> (hopefully) easily?
>
> Thanks,
>
> Lisa
>
> Lisa Cruz
> Teledermatology System Administrator
> Office of Clinical Operations
> Great Plains Regional Medical Command
> 2410 Stanley Rd., Suite B-17
> Ft Sam Houston, Texas 78234-6230
> 210-295-2705 DSN: 421-2705
> Fax: 210-295-2345 DSN: 421-2345
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
