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
24 COLUMNS | TOP
920 | H93 | F98OWSEC One World Security
6 INDICIES | TOP
920 | H93 | F98OWSEC One World Security
1: Primary (Primary/Unique)
| Element | Alias | Description | Sequence |
| 1 |
USER |
User ID |
Ascending |
| 2 |
SECF1 |
Data Source |
Ascending |
2: User
| Element | Alias | Description | Sequence |
| 1 |
USER |
User ID |
Ascending |
3: DataSource
| Element | Alias | Description | Sequence |
| 1 |
SECF1 |
Data Source |
Ascending |
4: DataSource User
| Element | Alias | Description | Sequence |
| 1 |
SECF1 |
Data Source |
Ascending |
| 2 |
USER |
User ID |
Ascending |
5: Group
| Element | Alias | Description | Sequence |
| 1 |
UGRP |
User / Role |
Ascending |
| 2 |
USER |
User ID |
Ascending |
| 3 |
SECF1 |
Data Source |
Ascending |
6: SystemUser
| Element | Alias | Description | Sequence |
| 1 |
SECUSR |
System User |
Ascending |
| 2 |
SECF1 |
Data Source |
Ascending |