You can get a report on a view with sp_help. For example:
sp_help hiprice
Name Owner type --------- ------ ----- hiprice dbo view (1 row affected)
Data_located_on_segment When_created ------------------------------ -------------------- not applicable July 7 1997 11:57AM
Column_name Type Length Precision Scale ----------- ------- ------ --------- ----- title_id tid 6 NULL NULL title varchar 80 NULL NULL type char 12 NULL NULL pub_id char 4 NULL NULL price money 8 NULL NULL advance money 8 NULL NULL total_sales int 4 NULL NULL notes varchar 200 NULL NULL pubdate datetime 8 NULL NULL contract bit 1 NULL NULL
Nulls Default_name Rule_name Identity ------ ------------ --------- -------- 0 NULL NULL 0 0 NULL NULL 0 0 NULL NULL 0 1 NULL NULL 0 1 NULL NULL 0 1 NULL NULL 0 1 NULL NULL 0 1 NULL NULL 0 0 NULL NULL 0 0 NULL NULL 0 No defined keys for this object. (return status = 0)
