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]
