Click here to monitor SSC

Damon Armstrong

Caffeine Induced Tirades about .NET and Life
And don't forget to check out my latest Simple-Talk articles
View Damon Armstrong's profile on LinkedIn      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
Latest articles
Checking Out SQL Backup Pro 7’s New Automatic Backup Verification
 Wouldn't it be great to offload the daily chore of checking the integrity of your production... Read more...

Chuck Lathrope: DBA of the Day
 Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to... Read more...

Backups, What Are They Good For?
 Pixar recently confessed, in an engaging video, that Toy Story 2 was almost lost due to a bad backup,... Read more...

C# Async: What is it, and how does it work?
 The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is... Read more...

SQL Server 2012 AlwaysOn
 SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It... Read more...