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 |
|
aoriju
Posting Yak Master
156 Posts |
 Posted - 2010-01-04 : 06:57:56
|
| Dear AllI am Working On a Big Application with SQL Server 2005 as BackEnd.We have almost 300 tables.I want to remove a column from a table ...Then how to find same Column name using other table...(Even if Foreign Key allocated or Not).....Any Query to identify the Column dependency on Various tableHelp MeRegardsRiju A.O |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-05 : 03:26:16
|
you can just use this to identify tables having particular columnSELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'your column' |
 |
|
|
|
|
|
Column Dependency On Various Tables