Naming Standards

Posted in 2003

Topics: Installation, Setup & Upgrades, Versions, Editions & End-of-Life

Demeis, Tony — Fri, 12 Sep 2003 18:38:01 — source: IIUG Forums & Mailing Lists

Hi, Has anyone used some good meaning naming standards for database tables? We have mainly data and code tables. I was trying to develop some standard table prefixes that would make them easily distinguish between the type table types, such as d_<table name> for data tables and c_<table name> for code tables. Of course I have to contend with the 18-character limit with IDS 7.31 until we upgrade. Any suggestions out there? Thank you, Tony Database Administrator

↪ replying to Demeis, Tony

Scott MacKenzie — Mon, 15 Sep 2003 15:17:43 — source: IIUG Forums & Mailing Lists

Tony, We use tblname_table for tables, and tblname_rec for data. And, of course, tblname_blob for blobs. Good enough granularity for our needs. Demeis, Tony wrote: > Hi, > > Has anyone used some good meaning naming standards for database tables? We > have mainly data and code tables. I was trying to develop some standard > table prefixes that would make them easily distinguish between the type > table types, such as d_<table name> for data tables and c_<table name> for > code tables. Of course I have to contend with the 18-character limit with > IDS 7.31 until we upgrade. Any suggestions out there? > > > Thank you, > Tony > Database Administrator > -- ( ______ )) .-- Scott MacKenzie; Dine' College ISD --. >===<--. C|~~| (>--- Phone/Voice Mail: 928-724-6639 ---<) | ; o |-' | | \\\\--- Senior DBA/CARS Coordinator/Etc. --/ | _ | `--' `-- E: scottm at dinecollege dot edu -' `-----'