• dawryn (3/20/2012)


    Koen Verbeeck (3/20/2012)


    That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also stored in other catalog views. Not just the CREATE statement.

    All mentioned is stored in system catalogs to make views operational and takes minimal space required after create view statement is executed. Catalog views are one form of means to query data from system catalogs.

    I also agree. Can you CREATE anything without the extra minimal space consumed by the metadata.