Skip to content

Instantly share code, notes, and snippets.

@LitKnd

LitKnd/list-computed-columns-and-whether-they-are-persisted.sql

Created June 12, 2017 23:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save LitKnd/fa902f27e3214d739df428477ba23d3f to your computer and use it in GitHub Desktop.
Save LitKnd/fa902f27e3214d739df428477ba23d3f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
list-computed-columns-and-whether-they-are-persisted.sql
SELECT
sc.name as schema_name,
so.name as table_name,
cc.name as column_name,
cc.[definition],
cc.is_persisted
FROM sys.computed_columns as cc
join sys.objects as so on cc.object_id = so.object_id
join sys.schemas as sc on so.schema_id = sc.schema_id;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment