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
A SysAdmin's Guide to Change Management
 In the first in a series of monthly articles, ‘Confessions of a Sys Admin’, Matt describes the issues... Read more...

Exchange: Recovery Storage Groups
 It can happen at any time: You get a request, as Admin, from your company, to provide the contents of... Read more...

Build Your Own Virtualized Test Lab
 Desmon explains the fundamentals of building a test lab for Windows servers and Enterprise applications... Read more...

Rendering Hierarchical Data with the Treeview
 It sometimes happens that Web Server controls that visualize data don't quite fit with the way that... Read more...

SQL Server 2008: Performance Data Collector
 With Performance Data Collector in SQL Server 2008, you can now store performance data from a number of... Read more...