Variables for Reverse Engineering

%R%

Set to TRUE during reverse engineering

%S%

Allow to skip a word. The string is parsed for reverse but not generated

%D%

Allow to skip a numeric value. The numeric value is parsed for reverse but not generated

%A%

Allow to skip all Text. The text is parsed for reverse but not generated

%ISODBCUSER%

True if Current user is Connected one

%CATALOG%

Catalog name to be used in live database connection reverse queries

%SCHEMA%

Variable representing a user login and the object belonging to this user in the database. You should use this variable for queries on objects listed in database reverse dialog boxes, because their owner is not defined yet. Once the owner of an object is defined, you can use SCHEMA or OWNER

%SIZE%

Data type size of column or domain. Used for live database reverse, when the length is not defined in the system tables

%VALUE%

One value from the list of values in a column or domain

%PERMISSION%

Allow to reverse engineer permissions set on a database object

%PRIVILEGE%

Allow to reverse engineer privileges set on a user, a group, or a role