Re: [Nolug] Verbose SQL

Chris Reames wrote:

>Actually, I was referencing a previous query to provide continuity for the
>joke.
>However, I have run across this redundant schema before. The
>rationalization I received was to keep track of which objects were tables,
>views, queries etc.
>
>The idea is when you list objects, they are naturally grouped by the "tag"
>infront of the name.
>Also, you can name Tables, Views, Triggers etc similar names without trying
>to keep track of spelling variations.
>
>Thats my 2 cents.
>
>
>
>>-----Original Message-----
>>From: owner-nolug@joeykelly.net [mailto:owner-nolug@joeykelly.net]On
>>Behalf Of Petri Laihonen
>>Sent: Wednesday, September 29, 2004 10:52 AM
>>To: nolug@joeykelly.net
>>Subject: Re: [Nolug] Verbose SQL
>>
>>
>>That very well may be.
>>
>>The case here could be that there are different types of files visible in
>>the same workspace, and one uses "tbl" to differentiate tables from for
>>example stored procedures.
>>
>>I don't know what kind of database is in question, but sometimes that
>>might be the only way to keep things logically organized.
>>
>>P
>>
>>
>>
>>>I'm guessing Mark's comment was about DB design, not query
>>>implementation, right? Otherwise, you would have to reference the
>>>actual table name when implementing your query.
>>>
>>>Jonathan
>>>
>>>Petri Laihonen wrote:
>>>
>>>
>>>
>>>>>Chris Reames wrote:
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Select Democrats=(select count(voters) from tbl_state_list where vote
>>>>>>LIKE
>>>>>>'yes', Republicans=(select count(voters) from tbl_state_list
>>>>>>
>>>>>>
>>where vote
>>
>>
>>>>>>LIKE
>>>>>>'no', Totals=(select count(voters) from tbl_state_list where vote is
>>>>>>not
>>>>>>null) from tbl_state_list where st_code='Florida'
>>>>>>
>>>>>>
>>>>>Since you aren't the first to do this, I'll ask: why include "tbl" in
>>>>>the name of a database table? Should we put "col" or "fld" in
>>>>>
>>>>>
>>the names
>>
>>
>>>>>of the columns of the table? Or "db" in the name of the database we
>>>>>connect to?
>>>>>
>>>>>It seems redundant: why do it?
>>>>>
>>>>>
>>>>>
>>>>>
>>>>I suspect the table name IS "tbl_state_list"
>>>>Therefore can not be found with "state_list"
>>>>
>>>>Petri
>>>>
>>>>___________________
>>>>Nolug mailing list
>>>>nolug@nolug.org
>>>>
>>>>
>>>>
>>>___________________
>>>Nolug mailing list
>>>nolug@nolug.org
>>>
>>>
>>>
>>___________________
>>Nolug mailing list
>>nolug@nolug.org
>>
>>
>>
>
>___________________
>Nolug mailing list
>nolug@nolug.org
>
>
>
'v' in front of view names and 'q' in front of query names, nothing in
front of table names seems ample differentiation and saves a lot of
typing, since tables are the most frequently-referenced objects.

___________________
Nolug mailing list
nolug@nolug.org
Received on 09/29/04