I'm looking to put together a little tool that will look at a stored procedure in a running database and give me a list of tables used by it.
I'm also looking to have similar code to look at a table and get all the triggers and constraints listed in it.
-
qwert231
M Kenyon
-
You can use INFORMATION_SCHEMA or the sys views and tables to get that sort of information.
-
vbrunner__
code monkey
You may also want to try the Microsoft.SqlServer.Smo assembly/namespace.
-
littleguru
<3 Seattle
The OleDbConnection has also a GetOleDbSchemaTable method. You could use that too...
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.