Scribd
Upload
9 views1 page

The Term "Global Permanent Table" Is Unique To This Book. The Help and Other Sources Just Call Them "Tables" or Sometimes "Base Tables."

There are several types of database tables: - Global permanent tables exist in the current database and their schema and data are available to all connections and persist until explicitly dropped or deleted. - Remote tables exist in a different database or file and are visible in the current database via proxy tables. Their schema and underlying data persist similarly to global permanent tables. - Proxy tables map the schema in the current database to the data in a remote table in a different database or file, allowing remote tables to be accessed like global permanent tables. - Global temporary tables have a persistent schema but temporary data that exists only for each connection and is deleted automatically when the connection ends. - Local temporary tables have both a temporary schema and

Uploaded by

Nishki Gejmer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

The Term "Global Permanent Table" Is Unique To This Book. The Help and Other Sources Just Call Them "Tables" or Sometimes "Base Tables."

There are several types of database tables: - Global permanent tables exist in the current database and their schema and data are available to all connections and persist until explicitly dropped or deleted. - Remote tables exist in a different database or file and are visible in the current database via proxy tables. Their schema and underlying data persist similarly to global permanent tables. - Proxy tables map the schema in the current database to the data in a remote table in a different database or file, allowing remote tables to be accessed like global permanent tables. - Global temporary tables have a persistent schema but temporary data that exists only for each connection and is deleted automatically when the connection ends. - Local temporary tables have both a temporary schema and

Uploaded by

Nishki Gejmer
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Chapter 1: Creating 5

| <create_local_temporary_table>
| <declare_local_temporary_table>
| <select_into_local_temporary_table>
Global permanent tables are the most common type. They exist in the current
database and both the schema and data are available globally to all connections
that have the appropriate permissions. The schema is permanent until the table
is explicitly dropped, and the data is permanent until it is explicitly deleted.

Note: The term global permanent table is unique to this book. The Help
and other sources just call them tables or sometimes base tables.

Remote tables exist in some other database or file, different from the current
database, and they are only visible in the current database via proxy tables.
Remote tables dont actually have to be tables in the strictest sense; they simply
have to look and feel like tables as far as the proxy table interface is concerned.
Remote tables can be spreadsheets, text files, or even views involving other
tables and views. Otherwise, remote tables are similar to global permanent
tables in that their schema and the underlying data are permanent.
Proxy tables exist in two places at once. The schema exists in the current
database but the actual data sits somewhere else, in a remote table in a different
database or file. The term proxy means surrogate or substitute; each proxy
table is a mapping between the data in a remote table and the schema in the cur-
rent database.
Proxy tables are a mechanism for treating remote tables as if they were
global permanent tables: They are available to all connections, and the schema
and data are permanent. Proxy tables are often used to gather data from other
sources, including legacy databases, distributed databases, spreadsheets, and flat
files. It is possible to update proxy tables as well as query them, and the changes
are reflected in the other data source.
Global temporary tables exist in the current database. The schema is perma-
nent and available to all connections, but the data is temporary: Each connection
inserts its own data, that data is visible only to that connection, and it is auto-
matically deleted when the connection is dropped. The data may also be deleted
each time a COMMIT or ROLLBACK is executed.
Local temporary tables exist in the current database. Both the schema and
data are temporary: Each connection must create the table and insert its own
data, and the table and data are both visible only to that connection. The table is
automatically dropped when the connection is dropped or when the table name
falls out of scope. The data may be automatically deleted when a COMMIT or
ROLLBACK is executed; otherwise, it lasts until the table is dropped. There are
three different statements that create temporary tables, one of which inserts data
at the same time.

You might also like