View computed columns in database
Snippet to quickly view computed column information. You can also view this by doing a "create table" script. This however, was a little cleaner to read and view for me.
select database_name = db_name() ,object_schema_name = object_schema_name( object_id ) ,object_name = object_name( object_id ) ,full_object_name = object_schema_name( object_id ) + '.' + object_name( object_id ) ,column_name = name ,cc.is_persisted ,cc.Definition from sys.computed_columns cc order by full_object_name asc