Browse by Tags

All Tags » tsql » columns » computed
  • TSQL to find computed column expression columns

    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) AS dependent_computed_column ,cc.definition AS computed_column_definition FROM ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on July 27, 2007