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 |
mohan123
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-01-13 : 03:00:13
|
i have written query to find out column names of a table in the database .SELECT t.NAME AS TABLEName ,SCHEMA_NAME(schema_id)+'.'+c.name AS ColumnNameFROM sys.tables tINNER JOIN sys.columns c ON c.object_id = t.object_idWHERE OBJECT_NAME(c.object_id) LIKE '%Message%'ORDER BY t.NAME So far i got the Expected result but what ever column i am looking i want to find out the Dependency of column realted tables. by executing the above query i am getting table name and column name. How can i get the column related dependent tables . Suggest me P.V.P.MOhan |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-13 : 05:55:47
|
http://visakhm.blogspot.in/2010/01/finding-cross-server-cross-db-object.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|