Re: Foreign Key Question

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 14:32:43 -0600

> Anyway, all I was saying was I can understand it, and it makes a hell of a
> lot more sense than tbl. There are plenty of reasons against it, and I
> can
> understand that too.
>
I know, I know I wasn't so much disagreeing with you as I was trying to
validate my own opinions. This group can be a good baptism by fire for
ideas.

> Great, religious war forthcoming, good going Louis. :-)

I seem to have a knack at that sometimes 

-- 
----------------------------------------------------------------------------
Louis Davidson - drsql@hotmail.com
SQL Server MVP
Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design - 
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are interested in 
consulting services.  All other replies may be ignored :)
"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message 
news:%23gqsPZP9EHA.3416@TK2MSFTNGP09.phx.gbl...
>> I used to, but then I had to ask, why?  Anyone who needs to know if it is
> a
>> view or not can tell from the catalog.
>
> That depends on how much access they have to the catalog.  In a lot of
> places, people don't have direct access to the database, but can see the
> code that returns certain select (e.g. SELECT * FROM vConsumers).  If I 
> have
> a view that joins multiple tables, there are situations where I'm going to
> do whatever it takes to prevent people from trying to do willy-nilly
> updates/inserts if they get a consumer back that doesn't look right.
>
> If I have a table consumers, and I have a view that pulls in a few columns
> from other tables, I'm probably likely to call it vConsumers, instead of
> Consumers_With_A_Few_Extra_Columns.
>
> Anyway, all I was saying was I can understand it, and it makes a hell of a
> lot more sense than tbl.  There are plenty of reasons against it, and I 
> can
> understand that too.
>
> Great, religious war forthcoming, good going Louis.  :-)
>
>

Relevant Pages
Quantcast