List views in Snowflake with their scripts

Query below finds all views in a database with their script.


select table_schema,
    table_name as view_name,
    created as create_date,
    last_altered as modify_date,
    comment as description
from information_schema.views
where table_schema != 'INFORMATION_SCHEMA'
order by table_schema,


  • schema_name - schema name of the view
  • view_name - name of the view
  • view_definition - definition (script) of the view
  • create_date - date and time the view was created
  • modify_date - last modification date and time of the view
  • description - description of the view


  • One row represents a view
  • Scope of rows: all found views
  • Ordered by schema name, view name

Sample results

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