Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.
Select SQL
Insert SQL
Update SQL
Create SQL
33 COLUMNS | TOP
920 | H95 | F00950 Security Workbench Table
10 INDICIES | TOP
920 | H95 | F00950 Security Workbench Table
1: TYPE USER OBJ DTAI (Primary/Unique)
| Element | Alias | Description | Sequence |
| 6 |
SY |
Product Code |
Ascending |
| 5 |
FRDV |
From Data Value |
Ascending |
| 4 |
DTAI |
Data Item |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
2: TYPE USER OBJ SY
| Element | Alias | Description | Sequence |
| 4 |
SY |
Product Code |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
3: TYPE USER OBJ OBID
| Element | Alias | Description | Sequence |
| 5 |
OBID |
Object Identifier |
Ascending |
| 4 |
FMNM |
Form Name |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
4: TYPE USER OBJ FMNM EXIT
| Element | Alias | Description | Sequence |
| 5 |
EXITID |
Exit Identifier |
Ascending |
| 4 |
FMNM |
Form Name |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
5: TYPE USER OBJ FMNM TABID
| Element | Alias | Description | Sequence |
| 5 |
TABID |
Tab Identifier |
Ascending |
| 4 |
FMNM |
Form Name |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
6: TYPE USER PATH
| Element | Alias | Description | Sequence |
| 3 |
PTH |
Path |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
7: TYPE OBNM
| Element | Alias | Description | Sequence |
| 2 |
OBNM |
Object Name |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
8: User
| Element | Alias | Description | Sequence |
| 1 |
USER |
User ID |
Ascending |
9: TYPE USER OBJ DTAI FROM ATN3
| Element | Alias | Description | Sequence |
| 7 |
ATN3 |
Reserve Action 3 |
Ascending |
| 6 |
THDV |
Thru Data Value |
Ascending |
| 5 |
FRDV |
From Data Value |
Ascending |
| 4 |
DTAI |
Data Item |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |
10: TYPE USER OBJ PATH
| Element | Alias | Description | Sequence |
| 4 |
PTH |
Path |
Ascending |
| 3 |
OBNM |
Object Name |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 1 |
SETY |
Security Type |
Ascending |