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
31 COLUMNS | TOP
910 | H95 | F00926 Anonymous User Access Table
5 INDICIES | TOP
910 | H95 | F00926 Anonymous User Access Table
1: User Id Language Preference (Primary/Unique)
| Element | Alias | Description | Sequence |
| 1 |
USER |
User ID |
Ascending |
| 2 |
LNGP |
Language |
Ascending |
3: WebUser
| Element | Alias | Description | Sequence |
| 1 |
WUID |
Web User Identifier |
Ascending |
4: Role Description
| Element | Alias | Description | Sequence |
| 1 |
ROLEDESC |
Role Description |
Ascending |
6: Sequence Number
| Element | Alias | Description | Sequence |
| 1 |
SEQNO |
Sequence Number |
Ascending |
8: Use Intensity
| Element | Alias | Description | Sequence |
| 1 |
USEINTENSE |
Use Intensity |
Ascending |