Nicholas,
you need to look at the following tables.
sysdatabases - has all the databases defined in your system
syscolumns - has all the columns defined in every table and view in
your system
syscomments - this has all info on each rule, constraint, default,
trigger and
stored procedure on your system including source
sysdepends - this has all the relationships between all the objects
in the system.
sysobjects - this has all the objects defined in the system.
sysindexes - it's name says it all
sysforeignkeys - same
I may have overlooked a few but these are the main tables you need to
look at.
Regards,
Jim
>Currently I am migrating a web app from a Sybase database to a MS SQL server
>database. I have a admin section that allows administrators to print reports
>on table structures, stored procedures, triggers, functions, indexes and
>foreign keys. My problem is that I can't find any information on where in
>the system tables Microsoft stores their function, trigger, and procedure
>definitions. How are they stored within SQL Server? What system tables and
>fields is this information located in: the table the trigger resides in, the
>name of the trigger, and its definition (source code)?
>Thanks,
>Nicholas W. Watson
>Assistant Web Developer
>Concurrent Technologies Corporation
>Email: [EMAIL PROTECTED]
>Phone:(814) 269 - 2653
--------------------------------------------------------------------------------
B L A Z E i n t e r . N E T
103 Pleasant Ave #2 | Jim Finucane - ST
Upper Saddle River, NJ 07458 | jim(at)blaze(dot)net
201-825-1313 Fax-825-4949 | http://www.blaze.net
--------------------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
