Hmmm - not sure about that - but I do know that you can run various system stored procs against a table to retrieve the info
There are loads like sp_help 'tablename' sp_helpconstraint 'tablename' sp_helpindex 'tablename' that return the kind of info you're requiring. -----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]
