| CASE Studio 2 |
|
|
|
|
|
|
|
|
| Full & Lite versions |
|
| General |
|
|
|
|
Databases
| Reverse Engineering |
Referential Integrity;
Indexes;
Queries
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
User-defined Triggers;
Views;
Alternative Keys;
Drop table;
Drop index;
Drop user-def. Trigger
Drop View;
Insertions before script;
Insertions after script;
Referential Integrity;
Indexes;
Queries
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Referential Integrity;
Indexes;
Queries
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
User-defined Triggers;
Views;
Alternative Keys;
Drop table;
Drop index;
Drop user-def. Trigger
Drop View;
Insertions before script;
Insertions after script
Generate table comments;
Generate attribute comments;
Use attribute names for empty captions
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
User-defined Triggers;
Drop table;
Drop index;
Drop user-def. Trigger Insertations before script;
Insertations after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Tablespace for tables;
Check constraints;
Unique constraints;
Indexes;
Triggers;
Procedures;
Views;
Sequences;
Users and Groups;
Permissions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for Ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternative Keys;
Roles permissions;
User permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop View;
Insertions before script;
Insertions after script
Generate Owner;
Generate Table Description;
Generate Column Description;
Generate Summary Tables;
Generate Identify Columns;
Generate Sequences;
Drop Summary Tables;
Drop Sequences
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Sequences;
Identify Columns;
Summary Tables
|
| Reverse Engineering |
Check constraints;
Unique constraints;
Indexes;
Triggers;
Procedures;
Views;
Users and Groups;
Permissions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for Ref. Integrity;
User-defined Triggers;
Views;
Alternative Keys;
Roles permissions;
User permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop View;
Insertions before script;
Insertions after script
Generate Table Description;
Generate Column Description
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Identify Columns;
Summary Tables
|
| Reverse Engineering |
Encrypted tables;
Table passwords;
Indexes
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
User-defined Triggers;
Drop table;
Drop index;
Drop user-def. trigger;
Insertions before script;
Insertions after script
Generate FullText Index
Generate Table Description;
Generate Column Description
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Only used user types;
Referential Integrity;
Check constraints;
Unique constraints;
Indexes;
Triggers;
Procedures;
Functions;
Views;
Aggregates;
Synonyms;
Users and Groups;
Permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for Ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternative Keys;
Roles;
Roles permissions;
User permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger;
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Use Quotations;
Generate Owner;
Generate Functions;
Generate Named ROW types;
Generate Distinct Types
Generate Opaque Types;
Generate Aggregates;
Generate Synonyms;
Drop Functions;
Drop Named ROW types;
Drop Distinct Types;
Drop Opaque Types;
Drop Aggregates;
Drop Synonyms
|
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Named ROW types;
Distinct types;
Opaque types;
Aggregates;
Synonyms
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for Ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternative Keys;
Roles;
Roles permissions;
User permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger;
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script |
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for Ref. Integrity;
User-defined Triggers;
Roles;
Roles permissions;
User permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger;
Drop procedure;
Drop View;
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Referential Integrity;
Check constraints;
Unique constraints;
Indexes;
Collations and Character sets;
Triggers; Procedures;
External Functions;
Views;
Exceptions;
Generators;
Blob filters;
Roles,
Users and Permissions;
Descriptions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Use Quotations;
Generate Functions;
Generate Exceptions;
Generate exceptions for triggers for RI;
Generate generators;
Generate Blob Filters;
Drop Functions;
Drop Exceptions;
Drop exceptions for triggers for RI;
Drop generators;
Drop Blob Filters;
Define temporary terminator for procedures and triggers
|
| Text Objects |
Others;
User Triggers;
Procedures;
Functions;
Views;
Before;
After;
Exceptions;
Generators
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Use Quotations;
Generate Exceptions;
Generate exceptions for triggers for RI;
Generate generators;
Drop exception;
Drop exceptions for triggers for RI;
Drop generators
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Referential Integrity;
Check constraints;
Unique constraints;
Indexes;
Collations and Character sets;
Triggers, Procedures;
External Functions;
Views;
Exceptions;
Generators;
Blob filters;
Roles;
Users and Permissions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script;
Create exception;
Drop exception
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity;
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Create exception;
Drop exception
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
User-defined Triggers;
Views;
Alternative Keys;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger;
Drop view;
Insertions before script;
Insertions after script;
Create exception;
Drop exception
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Filegroup for tables;
indexes and constrains;
Referential integrity;
Check constraints;
Unique constraints;
Indexes;
Fill factor;
Descriptions for tables and columns;
Triggers;
Procedures;
Functions;
Views, Users and Groups;
Permissions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Generate owner in tablenames;
Generate description on columns and tables;
Generate Functions;
Generate Extended stored procedures;
Drop Functions;
Drop Extended stored procedures
|
| Text Objects |
Others;
User Triggers;
Procedures;
Functions;
Views;
Before;
After;
Extended Stored Procedures
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
System commentary of InnoDB tables;
Indexes;
Unique Indexes as Alternate keys;
Referential Integrity, Users;
Permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
User-defined Triggers;
Alternate Keys;
User Permissions;
Drop table;
Drop index;
Drop user-def. trigger
Insertions before script;
Insertions after script
Generate Indexes to Foreign Keys automatically;
Generate table comments;
Generate FK's, AK's and Indexes in CREATE TABLE |
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Indexes;
Unique Indexes as alternate keys;
Users;
Permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
User-defined Triggers;
Alternate Keys;
User Permissions;
Drop table;
Drop index;
Drop user-def. trigger
Insertions before script;
Insertions after script
Generate table comments
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
all accessible objects "ALL_";
only procedures, functions, views, packages on selected schema;
only used user types, table space for tables;
table space for tables, indexes and constraints storage parameters for tables;
Check constraints;
Unique constraints;
Indexes Storage parameters for indexes;
Triggers;
Procedures and Functions;
Views;
Package and Package Bodies;
Synonyms;
Sequences;
Users, Groups and Permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script;
Use Quotations;
Generate owner;
Generate Check Constraint Name;
Generate Unique Constraint Name;
Generate NOT NULL Constraint Name;
Generate Comments on Tables;
Generate Comments on Attributes;
Generate Object Types and Object Type Bodies;
Generate Functions;
Generate packages and Package Bodies;
Generate Synonyms;
Generate Sequences;
Drop Object Types and Object Type Bodies;
Drop Functions;
Drop packages and Package Bodies;
Drop Synonyms;
Drop Sequences
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Functions;
Packages;
Package bodies;
Object Types;
Object Type Bodies;
Sequences;
Synonyms
|
| Reverse Engineering |
all accessible objects "ALL_";
only used user types;
table space for tables, indexes and constraints;
storage parameters for tables Check constraints;
Unique constraints;
Indexes Storage parameters for indexes;
Triggers;
Procedures and Functions;
Views;
Package and Package Bodies;
Synonyms;
Sequences;
Users,
Groups and Permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script;
Use Quotations;
Generate Check Constraint Name;
Generate Unique Constraint Name;
Generate NOT NULL Constraint Name;
Generate Comments on Tables;
Generate Comments on Attributes;
Generate Object Types and Object Type Bodies;
Generate Functions;
Generate Packages and Package Bodies;
Generate Synonyms;
Generate Sequences;
Drop Object Types and Object Type Bodies;
Drop Functions;
Drop packages and Package Bodies;
Drop Synonyms;
Drop Sequences
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Functions;
Packages;
Package bodies;
Object Types;
Object Type Bodies;
Sequences;
Synonyms
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
User-defined Triggers;
Drop table;
Drop index;
Drop user-def. trigger
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Load referential integrity;
Load unique constraints and indexes;
Load unique constraints on attribute with datatype IDENTITY or SMALLIDENTITY;
Load NOT NULL constraint names;
Load triggers;
Load procedures;
Load views;
Load users and groups;
Load permissions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After
|
| Reverse Engineering |
Check constraints;
Unique constraints;
Referential integrity;
Indexes;
Triggers;
Procedures and Functions;
Views;
Sequences;
Users,
Groups and Permissions;
Descriptions;
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop Domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Use Quotation
Generate Schema-Qualified Names;
Generate Users;
Generate User-Defined Types;
Generate User-Types Procedures;
Generate Schemas;
Generate Sequences;
Generate Descriptions on Tables;
Generate Descriptions on Columns;
Drop User-Defined Types;
Drop User-Types Procedures;
Drop Schemas
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
Sequences;
User-Type Definitions;
User-Type Procedures;
Schemas
|
| Reverse Engineering |
Check constraints;
Unique constraints;
Referential integrity;
Indexes;
Triggers;
Procedures and Functions;
Views;
Users, Groups and Permissions;
Descriptions
|
| SQL Script Generation |
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script;
Generate User;
Generate User-Defined Types;
Generate User-Defined Procedures;
Generate Descriptions on Tables;
Generate Description on Columns;
Drop User-Defined Types;
Drop User-Defined Procedures
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
User-Type Definitions;
User-Type Procedures
|
| Reverse Engineering |
not supported
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop Domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
Referential integrity;
Check constraints;
Unique constraints;
Indexes;
Triggers;
Procedures;
Functions;
Views;
Sequences;
Users and Groups;
Permissions
|
| SQL Script Generation |
Domains;
Tables;
Others;
Primary Keys;
Indexes;
Referential Integrity;
Triggers for ref. Integrity
User-defined Triggers;
Procedures;
Views;
Alternate Keys;
Roles;
Roles Permissions;
User Permissions;
Drop Domain;
Drop table;
Drop index;
Drop trigger;
Drop user-def. trigger
Drop procedure;
Drop view;
Users in roles;
Insertions before script;
Insertions after script
Generate Owner in Tablename;
Dbo Objects;
Generate Functions;
Drop Functions
|
| Text Objects |
Others;
User Triggers;
Procedures;
Views;
Before;
After;
|
| Reverse Engineering |
This section includes all the items which could be loaded
during the reverse engineering.
|
| SQL Script Generation |
This section includes all the items which could be generate by CASE Studio 2.
You have to check appropriate checkboxes only.
In bold are written all items from the Advanced tab of the Script Generating dialog window.
|
| Text Objects |
List of items supported as Text objects.
|
|
|
Database design