Browse by Tags

All Tags » computed   (RSS)
TSQL to find computed column expression columns
27 July 07 12:34 AM | SQL Master | 1 Comments   
USE <dbname>; GO SELECT OBJECT_NAME(d.referenced_major_id) AS referenced_name ,COL_NAME(d.referenced_major_id, d.referenced_minor_id) AS referenced_columns ,OBJECT_NAME(referenced_major_id) AS dependent_object_name ,COL_NAME(d.object_id, d.column_id) Read More...