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]
