• Koen Verbeeck (3/20/2012)


    According to CREATE VIEW (Transact-SQL):

    When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.

    Information that is stored in system tables also consumes space...

    None of those system catalog views are indexed. Which means they aren't materialized. Which means data in them doesn't take up additional space.