Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkSqlGUID | uniqueidentifier | 16 | (newid()) |
|
|
Primary key - sql unique identifier for each record |
||
| sqlSelect | varchar | 3000 | √ | null |
|
|
SELECT clause - SELECT portion of the SQL query |
|
| sqlAggregates | varchar | 200 | √ | null |
|
|
Aggregate functions - Aggregate functions and calculations |
|
| sqlFrom | varchar | 1200 | √ | null |
|
|
FROM clause - FROM portion specifying tables and joins |
|
| sqlWhere | varchar | 3000 | √ | null |
|
|
WHERE clause - WHERE conditions and filters |
|
| sqlGroup | varchar | 300 | √ | null |
|
|
GROUP BY clause - GROUP BY fields for aggregation |
|
| sqlOrder | varchar | 200 | √ | null |
|
|
ORDER BY clause - ORDER BY fields for sorting |
|
| sqlPaging | varchar | 200 | √ | null |
|
|
Paging parameters - Parameters for result paging and pagination |
|
| notes | varchar | 200 | √ | null |
|
|
Query notes - Documentation and notes about the query purpose |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_sql | Primary key | Asc | pkSqlGUID |