Re: [sqlite] What's the collective term for table, view, trigger etc?

2007-01-06 Thread Derrell . Lipman 
T <[EMAIL PROTECTED]> writes:

> Is there a standard (or even non-standard) term that refers to the  tables,
> triggers, views, indexes (any others?) in a database?

The collective term for all of the definitions taken together is the "schema"
of the database.

Derrell

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] What's the collective term for table, view, trigger etc?

2007-01-06 Thread RB Smissaert 
> Is there a standard (or even non-standard) term that refers to the  
> tables, triggers, views, indexes (any others?) in a database?

I have seen the term relations being used for this.

RBS

-Original Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED] 
Sent: 06 January 2007 15:06
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] What's the collective term for table, view, trigger
etc?

> Is there a standard (or even non-standard) term that refers to the  
> tables, triggers, views, indexes (any others?) in a database?

Thingamajiggies.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] What's the collective term for table, view, trigger etc?

2007-01-06 Thread Joe Wilson 
> Is there a standard (or even non-standard) term that refers to the  
> tables, triggers, views, indexes (any others?) in a database?

Thingamajiggies.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] What's the collective term for table, view, trigger etc?

2007-01-06 Thread P Kishor 

entities

On 1/6/07, T <[EMAIL PROTECTED]> wrote:

Hi All,

Is there a standard (or even non-standard) term that refers to the
tables, triggers, views, indexes (any others?) in a database?

Their definitions all reside in the sqlite_master table, as returned by:

sqlite> SELECT name, type FROM sqlite_master;

which yields a list like:

Staff   table
Payroll table
Paycheckview
Roster  view
NewStafftrigger

So what would I say that they all (Staff, Payroll, Paycheck, Roster,
NewStaff) are? There must be something more descriptive (and
understood?) than "database item".

Thanks,
Tom


-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] What's the collective term for table, view, trigger etc?

2007-01-06 Thread T 

Hi All,

Is there a standard (or even non-standard) term that refers to the  
tables, triggers, views, indexes (any others?) in a database?


Their definitions all reside in the sqlite_master table, as returned by:

sqlite> SELECT name, type FROM sqlite_master;

which yields a list like:

Staff   table
Payroll table
Paycheckview
Roster  view
NewStafftrigger

So what would I say that they all (Staff, Payroll, Paycheck, Roster,  
NewStaff) are? There must be something more descriptive (and  
understood?) than "database item".


Thanks,
Tom


-
To unsubscribe, send email to [EMAIL PROTECTED]
-