Home Forums SQL Server 2012 SQL Server 2012 - T-SQL If I understand Views VS Functions correctly...I should use views to enapsulated commonly used where clauses? RE: If I understand Views VS Functions correctly...I should use views to enapsulated commonly used where clauses?

  • May 5, 2014 at 12:36 pm

    #1710844

    Sean Lange (5/5/2014)

    Phillip.Putzback (5/5/2014)

    Do you use a naming convention for lookup tables so report writers have a way of noticing them before they go create their own? Their own schema or prefix perhaps?

    I agree with other poster who suggested using a separate database for this. That is a good idea. So is using a specific schema. Either of these two approaches is clean and manageable. Prefixes on object names are just ugly for a number of reasons and should be avoided.

    It does make for some ugly, and long table names. Thats why we do the database, do that if you can. Schema would be my second option. You have to be careful when using the schema that someone doesn't create the same name different schema on same database and then accidentally delete both tables. That happened, once.

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.