Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - ER Modeler |
| Version | 10.0 |
Add identity definition to entity display on ER model if it exists.
|
|
19 KB
1. Is this for 9.0 or 10.0?
2. Should identity be displayed when physical schema option is off? Currently, only the name is shown.
3. what should be the format? int IDENTITY(1,1)?
Decided to indicate identity as I before * using the same violet color.
This functionality is database specific - I would have to guess the criteria for each database type.
Decided to indicate identity as I before * using the same violet color.
This functionality is database specific - I would have to guess the criteria for each database type.
The logic is as follows:
No identity logic:
informix, ncluster, netezza, teradata
only if IDENTITY == YES
mssql, mysql, oracle, postresql, syany, syase, syiq
only if IDENTITY == ALWAYS
db2, db2i, db2zOS, derby,
(what should we do in case of IDENTITY==DEFAULT?)
The logic is as follows:
No identity logic:
informix, ncluster, netezza, teradata
only if IDENTITY == YES
mssql, mysql, oracle, postresql, syany, syase, syiq
only if IDENTITY == ALWAYS
db2, db2i, db2zOS, derby,
(what should we do in case of IDENTITY==DEFAULT?)
Tariq indicated that there might be additional logic for identity columns (primary keys, first column, etc.).
Please advise.
Tariq indicated that there might be additional logic for identity columns (primary keys, first column, etc.).
Please advise.
Issue #6055 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
1. Is this for 9.0 or 10.0?
2. Should identity be displayed when physical schema option is off? Currently, only the name is shown.
3. what should be the format? int IDENTITY(1,1)?