October 2, 2012 at 6:19 am
As far as naming conventions, as a DBA I enforce them and I do not allow prefixes for tables.
If you feel comfortable with 'tbl' as a Table prefix then go for it.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 2, 2012 at 7:02 am
Welsh Corgi (10/2/2012)
As far as naming conventions, as a DBA I enforce them and I do not allow prefixes for tables.If you feel comfortable with 'tbl' as a Table prefix then go for it.
My opinion, exactly 😀
October 2, 2012 at 7:09 am
If the Standard is to not use prefix table names and you were told not to use them then I guess you don't have any choice.
That is unless you don't want your code to get promoted to QA.:-D
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 2, 2012 at 9:00 am
Welsh Corgi (10/2/2012)
If the Standard is to not use prefix table names and you were told not to use them then I guess you don't have any choice.That is unless you don't want your code to get promoted to QA.:-D
Just a few words to put a final period to this topic, at least as far as I'm concerned.
I work for a local branch of a multi-national company since 1991. I'm not sure whether the same is true in other parts of the world, but all European plants of this company use the same naming convention in every application (database related or not). This was already the case when we were working in VAX Cobol, VAX Fortran and VAX C, and it went on, with some refinements, when the Windows world gradually replaced the VAX-VMS systems, and it was extended to SQL Servers when these were introduced in the network. It is presently used on 250+ SQL Server boxes in our European network. As far as I know (I don't work with Oracle), a similar convention is used for Oracle systems (more than 300 around the wold), although some variations may exist.
This might not be considered as "standard" by some (or many) people on this forum, but it's efficient and, once used to it, it saves countless hours of search in the programming notes of an ancient program you need to maintain, modify or re-factor, specially if you're not the author of the aforementioned program.
When I prepared and posted the first answer, my intention was to provide some help and open the path to a workable solution for someone who was needing it, surely not to initiate a controversial dogmatic discussion on good and bad practices, and surely not to be promoted to QA, which is something I actually don’t care about. 😉
October 2, 2012 at 3:50 pm
Let's play nice my friends.
Viewing 5 posts - 46 through 49 (of 49 total)
You must be logged in to reply to this topic. Login to reply