prefixing application name to a tablename
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: prefixing application name to a tablename

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    some people recommend adding applicatioon name prefix to all the table names. what are the advantages apart from from being able to identify which application does a table belong to ?

    satish

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    I do not see any advantage.

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    I would discourage that practice. I don't think categorizing data as "for an application" is very accurate. It is more likely for a business process, and in many cases transcends processes and even businesses. If you really just like having those object names prepended with the application name, then just create synonyms. For example:

    Owner name: Pat
    Table name: fred
    App name: flintstones

    Create public synonym flinstones_fred for pat.fred;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width