Oops! - sp_help returns pretty much everything you need on its own. -----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 July 2004 17:23 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] mySQL command equivalent in SQL Server[Scanned]
Rich Wild wrote: >I guess that shows the table generation script for that table? > >If so, you can generate scripts from enterprise manager. > > Yeah sorry - thats what it does. Unfortunately, I don't have access to the database from Enterprise manager, but I do have admin access via CF/ODBC, which is why I'm looking at SQL ways to get the info I need. I need to get the information about a table and any constraints that may be applied to that table, so that I can create a script to suck the structure and data out and then create a SQL script that can be applied to another server. Regards Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
