Browsing the blog archives for January, 2011

Identify All Computed Columns

Use the following query to identify all computed columns in a database:   List all computed columns SELECT    object_name(object_id) AS [Table Name]         , [name] AS [Column Name] FROM        sys.columns WHERE    is_computed = 1;

0 Comments