Oracle 9i - specifikace
generovßnφ skriptu SQL
Zßlo₧ka RozÜφ°enΘ a jejφ specifikace:
-
Use Quations - zaÜkrtnout pro generovßnφ tabulek, atribut∙, tablespace,
constraint, index and trigger names in quotation marks
-
Generate owner - zaÜkrtnout pro p°idßnφ informacφ o Vlastnφkovi (Schema)
do tabulky, indexu, trigger names. tato volba nenφ mo₧nß p°i generovßnφ domΘn (TYPE a TYPE BODY),
procedur, pohled∙, u₧ivatelsk²ch trigger∙ a balφΦk∙ (Packages a Package Bodies).
- Generate name of Check Constraint - zaÜkrtnout pro generovßnφ Check Constraint
names.
-
Generate name of Unique Constraint - zaÜkrtnout pro generovßnφ Unique Constraint
names
-
Generate name of NULL/NOT NULL Constraint - zaÜkrtnout pro generovßnφ NULL/NOT
NULL Constraint names
-
Generate comments on tables - zaÜkrtnout pro generovßnφ p°φkazu "Comment on
table" pro tabulky, kterΘ obsahujφ text v zßlo₧ce "description (Oprava entity)"
-
Generate comments on attribute - zaÜkrtnout pro generovßnφ p°φkazu "Comment
on column" command for a table which includes a text in the "description"
tab. (Editing entity)
-
Generate Functions - zaÜkrtnout pro generovßnφ funkcφ. VÜechny u₧ivatelskΘ funkce jsou p°φstupnΘ v menu - > Text Objects menu
functions are accessible via the Model - > TextovΘ objekty.
-
Generate Packages, Packages Bodies, Synonyms, Sequences - check
zaÜkrtnout pro generovßnφ v²Üe uveden²ch polo₧ek.
- Drop Functions, Packages, Packages Bodies, Synonyms, Sequences
- zaÜkrtnout pro zruÜenφ v²Üe uveden²ch polo₧ek
- Terminator - specifikace terminßtoru (implicitn∞ "\")
- prosφm zaÜkrtnout checkbox What to generate tab pro zp°φstupn∞nφ checkboxu Generate Procedures
Poznßmka: ZaÜkrtnutφ checkboxu "U₧ivatelskΘ typy jako domΘny"
(zßlo₧ka "jak generovat"') nemß v p°φpad∞ generovßnφ Oracle 9i ₧ßdn² vliv na v²sledn² skript
#