Damon Armstrong

Caffeine Induced Tirades about .NET and Life
And don't forget to check out my latest Simple-Talk articles
Add to Technorati Favorites      Add to Google     

Prefixing Database Tables

Published Wednesday, July 26, 2006 2:24 AM

Reviewing a database with 400 tables is no easy task, especially when you didn't make the database.  It seems like it would make everyone's life easier is if people would prefix their database tables in a way that helps group tables logically.

For example, there are tables in this 400 table database specifically used for configuring the application.  It would be nice if they were prefixed with "config_" to denote that they are configuration tables.  Instead of tables A, M, and Z intermingled with the rest of the tables in the database, they would be nicely grouped together as config_A, config_M, and config_Z

But even if everyone were to start prefixing their databases the way I want right now, it wouldn't help me out with the one I've already got.  A man can dream, though ... a man can dream.

by Damon
Filed Under:

Comments

 

drsql said:

In 2005 the best way to go would be if everyone would start making use of schemas to group tables together.  I have been using them on all of the tools I have been creating lately and they work great for this purpose.
July 26, 2006 8:47 AM
 

rjpaulsen said:

I agree Damon. On a similar note, I refuse to stop prefixing my objects with the object type txtMyTextBox and btnTheButton.

I use Mgt Studio, but currently we're still all Sql2000 databases. I'll give the schemas a try when we upgrade.

Sigh... Sure wish Sql2000 Database Diagrams worked from Mgt Studio.
July 26, 2006 10:04 AM
You need to sign in to comment on this blog

















<July 2006>
SuMoTuWeThFrSa
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345
Using Powershell to Generate Table-Creation Scripts
 For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for... Read more...

Configuring Exchange Server 2007 to Support Information Rights Management
 In Exchange Server 2007, Information Rights management is easy to set up once you have set up the... Read more...

SQL Response: The dim sum interview
 Richard Morris met David and Nigel of the SQL Response team, in a dim sum Restaurant in Cambridge. They... Read more...

Why This SQL Server DBA is Learning Powershell
 Ron describes how he decided to study Powershell as a single scripting system to automate all the... Read more...

Using Covering Indexes to Improve Query Performance
 Designers of database systems will often assume that the use of a clustered index is always the best... Read more...