General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Structure query
Environment versions
Network:
Windows 2000 Server
Is there a way to read the Stored Procedures, Index files, triggers, and the constraints from an SQL database?
By read I mean just a simple list of the items and their definition.
On index files and constraints, I need the item name and definition.
I know Stored Procedures & Triggers can get long, but I need a list of the items and a way to export the code for the stored procedure / trigger into a text file or some other easy to view format.
The prime intent of this is to be able to compare a development version of a database with the production versoion and be sure that I have moved all of the parts (index, SP, Triggers, Constraints) from Dev to production.
THANKS
Hope you have a good Christmas
Joel Hokanson
Houston, Texas
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only