SQL Server's hard per-table column cap.
SQL Server enforces a hard ~8060-byte in-row row size; only variable-length values go off-row.
SQL Server index keys are limited to 900 bytes → 450 NVARCHAR (2-byte) chars.
The data type mapping from SQL Server types to this platform's.
Wraps one DML statement so its affected-row count comes back as a one-row result set.
ALTER COLUMN clause(s) for type and nullability changes.
Wraps statements in one all-or-nothing transaction batch.
The auto-increment primary-key expression for DDL.
The batch separator.
The SQL type token for a boolean stored-procedure or function parameter.
SQL Server is case-insensitive for identifiers; the schema name is stored as-given.
SQL Server cannot index NVARCHAR(MAX) columns — cap to NVARCHAR(450).
CAST(expr AS <bounded string type>), defaulting to MJ's 450-character indexable width.
A CAST-to-UUID expression.
Description metadata SQL for a column.
CommentOnColumn unchanged, for platforms whose comment statement is idempotent.
A description (comment) statement for an object.
CommentOnObject terminated with ;, for platforms whose comment statement is idempotent.
A conditional IF/ELSE block in procedural SQL.
OptionalelseSQL: stringWhether the platform supports CREATE OR REPLACE for the object type.
SQL that marks a savepoint.
CREATE SCHEMA IF NOT EXISTS.
CREATE TABLE IF NOT EXISTS <fullTable> (...); as a single statement.
A CREATE TABLE wrapped in a create-if-not-exists guard.
The empty-GUID literal as a plain quoted string.
SQL Server-specific Flyway escape. Interleaves a CAST(N'' AS NVARCHAR(MAX))
between the split halves so the running T-SQL concat chain inherits
NVARCHAR(MAX) precedence. Without the cast, N'a' + N'b' produces
NVARCHAR(a+b) capped at NVARCHAR(4000) and silently truncates anything
past 4,000 characters.
Minimum in-row byte footprint of a column. Off-row-capable variable-length / LOB types
(incl. (N)VARCHAR(MAX)) contribute only a 24-byte in-row pointer; fixed-length types
contribute their full size. Unknown types are treated as off-row pointers (conservative).
SQL that checks whether a database object exists.
The fallback type for unknown abstract types.
SQL Server FK-graph query for cascade planning — reads the sys.foreign_keys catalog.
Returns one row per FK column with childNullable (from sys.columns.is_nullable) and
colCount (columns in the constraint, for composite exclusion). Both parent + child are
filtered to schema. Schema is embedded as a literal (no bind params) so it runs via
ExecuteSQL(sql).
DDL that creates a full-text index.
Optionalcatalog: stringA full-text search predicate.
A new UUID generation expression.
The default-value clause appended to a parameter declaration.
The parameter-reference syntax of stored-procedure / function bodies.
The syntax for calling a stored procedure or function.
A non-fatal signal statement detectable in CLI output.
SQL that releases a savepoint, or null when the platform has none.
Resolves an abstract schema field type to a concrete SQL type.
The clause that returns inserted values.
Optionalcolumns: string[]SQL that rolls back to a savepoint.
The row count variable or expression for the last statement.
Schema introspection queries.
The expression returning the last inserted identity value.
Splits on a ; followed by optional inline whitespace and a newline, trims each fragment,
drops empties, and ends each statement with ;.
A string-split row source expression.
The default expression for a UUID primary key.
SQL Server DDL, stored-procedure, migration, introspection and transaction SQL.