sqlmc_script_complete: Parameters

maxItems has a default because a caret at the start of a statement offers the whole dialect —hundreds of keywords — and everything past the first screenful is noise an agent pays for by thetoken.

Last updated 2026-10-21

caretOffset Required. Zero-based character offset of the caret. May equal the text's length
sql The script text. Give this or path, not neither
path A .sql file to read the text from, when sql is not given
workspace The .smcworkspace, or a folder holding one. Resolved automatically when omitted
connection Name or id of the registered connection whose schema resolves names here
database Database to resolve against, when it is not the connection's own
distributionList Target group whose last coverage scan annotates the items
maxItems Most items to return, best first. Defaults to 50

maxItems has a default because a caret at the start of a statement offers the whole dialect — hundreds of keywords — and everything past the first screenful is noise an agent pays for by the token. The engine ranks best-first, so a cap keeps what is worth having.

The input parameters of sqlmc_script_complete: caretOffset, the script text or path, the connection and database, and maxItems.
The input parameters of sqlmc_script_complete: caretOffset, the script text or path, the connection and database, and maxItems.