Thursday, September 22, 2005 8:34 PM
dbottjer
SQL Table Naming Conventions
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.
Filed under: SQL