Using Enterprise manager you can right click on the DB and choose "genera te SQL scripts" - it will automatically generate a create script for all or part of the DB, including views and indexes. Or.. you can choose the "diagram" icon and build a nice visual view. You can do everything in design view including managing constraints and changing data fields. I h ave used Design view to diagram MySQL databases in the past (by running a DTS import, then arranging the tables) - just so I can have a visual print ou t to work with. One more way is using the "object viewer" in the query anaylyzer (F8). Right click on a table and choose - generate script as "create". Good luck
Mark -----Original Message----- From: Andy Parry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 5:13 PM To: CF-Talk Subject: RE: (OT) SQL Server Schema You can do a join on sysobjects and syscolumns tables in your DB and get the data that way also. andy ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
