Either the generate scripts function or my experience is very limited. The scripts contain object ID references that seems to be specific to the SQL Server that generates the scripts. Additionally, don't expect the scripts to work on other RDBMs, such as MySQL or Oracle.
It might be useful just as a basic template and then delete the unnecessary parts. Personally, I believe the best option is to purchase PowerTools by Sybase. Sybase allows developers to create a system for most major DB systems. If you need the option to be able to create the table from a shell /command prompt, or can't afford Sybase I suggest a basic ANSI SQL script. At 05:06 PM 5/20/2002 +0100, you wrote: >Yup - in Enterprise Manager, right-click on the object you want and select >"Generate Scripts" > >-----Original Message----- >From: Ken Beard [mailto:[EMAIL PROTECTED]] >Sent: 20 May 2002 16:41 >To: CF-Talk >Subject: RE: MS SQL - Exporting table structures > > >yeah i think it's called "generate sql scripts" or something like that... >enterprise manager > > >-----Original Message----- >From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] >Sent: Monday, May 20, 2002 11:31 AM >To: CF-Talk >Subject: OT: MS SQL - Exporting table structures > > >I have seen this in MySQL editors, but does MS SQL have an export feature >that will export the table structures and such or an export that builds the >CREATE TABLE syntax for a list of tables. > >Any help would be great! > >Paul Giesenhagen >QuillDesign > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
