List views columns in SQL Server

Query below lists all columns in views in SQL Server database

Query

select schema_name(v.schema_id) as schema_name,
       object_name(c.object_id) as view_name,
       c.column_id,
       c.name as column_name,
       type_name(user_type_id) as data_type,
       c.max_length,
       c.precision
from sys.columns c
join sys.views v 
     on v.object_id = c.object_id
order by schema_name,
         view_name,
         column_id;

Columns

  • schema_name - view owner, schema name
  • view_name - view name
  • column_id - column number in view
  • column_name - column name
  • data_type - column datatype
  • max_length - data type max length
  • precision - data type precision

Rows

  • One row represents one column in a specific view in a database
  • Scope of rows: all columns in views in SQL Server database
  • Ordered by schema name, view name and column position

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.