SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 elaborate for me
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gavakie
Posting Yak Master

221 Posts

Posted - 10/01/2007 :  09:44:53  Show Profile  Visit gavakie's Homepage  Click to see gavakie's MSN Messenger address  Reply with Quote
Im a little lost. Someone posted this for me.
INFORMATION_SCHEMA.TABLES
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
INFORMATION_SCHEMA.COLUMNS


How does this help me find what tables are used in my storedprocedures and views. Im not quite sure how the syntax works on it. I cant find an example.

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/01/2007 :  10:38:31  Show Profile  Visit spirit1's Homepage  Reply with Quote
it doesn't really...
you have to use sp_depends stored procedure

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page

gavakie
Posting Yak Master

221 Posts

Posted - 10/01/2007 :  10:49:14  Show Profile  Visit gavakie's Homepage  Click to see gavakie's MSN Messenger address  Reply with Quote
I have tried that. The problem I am running into is if the Stored Proc has tables it use from a different DB then it wont show those.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 10/01/2007 :  11:31:58  Show Profile  Reply with Quote
Might help to know what problem you are trying to solve, there might be a different starting point
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 10/01/2007 :  11:34:17  Show Profile  Visit spirit1's Homepage  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90217

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000