• table , table [transaction]

    or

    table tuser, table ttransaction

    the t prefix helps when it comes to some common reserved words.

    I don't mind using t and v as prefixes on tables and views, when it comes to partitioned views the t prefix can be used,

    since logically the partitioned view has the physical role of a table.

    I also find it good to be able to easily distinguish between the 2 different objects (t+v) in code.

    2 cents on why I like t + v prefixes on t+v database objects.

    rockmoose


    You must unlearn what You have learnt