Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hmusa
Starting Member
36 Posts |
 Posted - 2002-03-13 : 10:03:31
|
I know you can right click on a table or view and select display dependancies, but does anyone know what tables are used to produce the result? I want to create a query that will show me the dependancies of an object via TSQL.Or does anyone now of a better way of achieving what I am trying to do?Any suggestions will be greatly appreciatedThanxs |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-13 : 10:16:17
|
| you can look at the INFORMATION_SCHEMA views in addition to syscolumns and sysobjects.-------------------------------------------------------------- |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-13 : 10:19:07
|
| How about sp_depends? Books Online details the information it returns. |
|
|
|
|
|
|
Object Dependancies