• I have been using the same approach for my sql2k5 standard boxes with great success. I have found that I routinely want to know if a view is (1) an indexed view, (2) a wrapper view for an indexed view, or (3) a traditional view. To that end, I use a nomenclature of *_BaseIV and *_IV for the first two cases-

    create table t1 (c1 int primary key);

    go

    /*indexed view*/

    create view myview1_BaseIV

    with schemabinding as

    select c1 from dbo.t1;

    go

    create unique clustered index myview1baseiv_ucidx_c1 on dbo.myview1_baseiv(c1);

    go

    /*wrapper for indexed view*/

    create view myview1_IV

    as select c1 from dbo.myview1_BaseIV with (noexpand);

    Naming them this way makes it so I can easily discern what type of view each is when scanning through the list of views in SSMS. I'll often times be looking for an indexed view that is an aggregate rollup of some table, so this makes it quite easy to locate.