Published: Jul 25 2011 / 06:21
Pretty solid advice (if you're using relational).
I always used Plural names for tables... Can someone shed some light why this might be bad?
I've always used plural names for tables (and underscores to separate words instead of using camel case). Just about every reference book I've read does as well. It makes sense to use plural names as tables don't hold only one piece of data.
TblSchool instead of just 'School' will make your complex queries readable.
And no TblSchools since its just one table.
I meant more like "Schools" instead of "School"
Hey it's a really nice article and one of my favourites.
Html tags not supported. Reply is editable for 5 minutes. Use [code lang="java|ruby|sql|css|xml"][/code] to post code snippets.