Geeks With Blogs
Dennis Bottjer | MVP

How do you name your SQL Tables?  Are the names singular or plural?  A friend suggested that tables should be singular because they represent a single record instance of data stored in the table.  When multiple records are selected then a collection is created.

For example, if you create a table called student each record in that table represents one student.  Each row or record in the student table represents one instant of the student table.  If you select several students from the student table you are creating a collection of student records.  The collection should be plural not the table name.

Posted on Friday, September 23, 2005 12:34 AM SQL | Back to top

Comments on this post: SQL Table Naming Conventions

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © DennisBottjer | Powered by: