Difference between revisions of "SQWareRepository:teradata"

From Wiki_dbSQWare
Jump to: navigation, search
(Created page with '{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}} == Schema content == {{SQWareRepositoryTables|tsqw_Repository| <nowiki>Instance repository</nowiki>| <pre> /* Instance …')
 
Line 1: Line 1:
 
{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}}
 
{{SQWareRepositoryPresSgbd|Teradata|schema|instances|ter}}
== Schema content ==
+
== Specific database content for Teradata ==
{{SQWareRepositoryTables|tsqw_Repository|
 
<nowiki>Instance repository</nowiki>|
 
<pre>
 
/* Instance repository */
 
.....
 
 
 
</pre>
 
}}
 

Revision as of 19:05, 8 August 2015

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqwter_% or isqwter_% are specific for Teradata.
Installation guide for SQWareRepository for Teradata

Naming convention

All specific objects for Teradata are named with prefixes:

  • tsqwter_% : for tables
  • isqwter_% : for index
  • isqwter_%_u : for uniques
  • isqwter_%_pk : for primary key


Nuvola apps important.png
Warning:
Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.

This will facilitate version upgrades.


Specific database content for Teradata