July 16, 2002 at 11:29 pm
Is there some sort of standard guideline as to how to name tables and columns in SQL? Mainly I'm wondering whether I should add prefixes followed by underscores to my column names, the prefixes representing the table (or, if it's a relational ID, the prefix of the other table). Thanks.
July 17, 2002 at 1:43 am
There are a number of articles submitted about this. Click the search menu above and search on 'naming and standards' to retrieve some relevant articles.
Regards,
Andy Jones
.
July 17, 2002 at 5:25 am
And some good forum threads too. Lots of varying opinions, worth doing some reading first. I think in general we recommend not using prefixes like "tbl", standardizing on either always using underscores or never to be consistent.
Andy
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply