The following describes the variable used by table expression.
- "tables" :
- Required, literal entry.
- Must be lowercase.
- The fully qualified name of an existing database table. The user invoking JSON_SHRED_BATCH must have the required privileges (INSERT, UPDATE, and so forth) on this table.
JSONID and ROWINDEX (uppercase or lowercase) are keywords. They are used to track the input JSON document ID value (the first column of the input query) and the index number for an input row, respectively. JSONID and ROWINDEX may be referenced in the table expression clause as a source value for the shredding operation.