I wrote a little CF utiltiy to do something very similar to this a while ago.
It's a custom tag which takes a datasource attribute. The custom tag generates a page containing a DHTML collapsable table definition for each of the user defined tables in the database. The table definition contains stuff like the data type, length, null or not for each column. It works for MSSQL 7 and 2000 databases. If anyone wants a copy send me a mail off list. Spike Stephen Milligan Team Macromedia - ColdFusion Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content Management' http://spikefu.blogspot.com > -----Original Message----- > From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED]] > Sent: 19 December 2002 14:58 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Help - SQL Table field diagramming > > > THAT's what I need! Thanks! > > 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 > > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 7:51 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Help - SQL Table field diagramming > > > the sp will show you the columns, the dependecies, the > constraints etc.. > > -----Original Message----- > From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED]] > Sent: 19 December 2002 13:55 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Help - SQL Table field diagramming > > > Will this also include the data? I only want table diagramming ...? > > 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 > > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 19, 2002 4:36 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Help - SQL Table field diagramming > > > use sp_help [your table name] you can then save it off as a > CSV file for import into Excel. > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED]] > Sent: 19 December 2002 10:31 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Help - SQL Table field diagramming > > > 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] > > -- > ** 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] > > -- > ** 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] > -- ** 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]
