Struct CreateTableAsClause
The options of a CREATE [TEMPORARY] TABLE ... AS SELECT clause, handed to
MakeCreateTableAsSelect(CreateTableAsClause, string, KeywordCase) so the dialect can spell the statement natively.
Table and Columns are already resolved and, when identifier quoting is
enabled, quoted by the caller — the dialect only places them.
public readonly record struct CreateTableAsClause : IEquatable<CreateTableAsClause>
- Implements
- Inherited Members
- Extension Methods
Constructors
CreateTableAsClause(string, bool, bool, IReadOnlyList<string>?, TempTableOnCommit, bool)
The options of a CREATE [TEMPORARY] TABLE ... AS SELECT clause, handed to
MakeCreateTableAsSelect(CreateTableAsClause, string, KeywordCase) so the dialect can spell the statement natively.
Table and Columns are already resolved and, when identifier quoting is
enabled, quoted by the caller — the dialect only places them.
public CreateTableAsClause(string Table, bool Temporary, bool IfNotExists, IReadOnlyList<string>? Columns, TempTableOnCommit OnCommit, bool WithData)
Parameters
TablestringThe target table name (resolved and optionally quoted).
TemporaryboolWhether the target is a temporary (session-scoped) table.
IfNotExistsboolWhether the statement carries
IF NOT EXISTS.ColumnsIReadOnlyList<string>The declared column names (resolved and optionally quoted), or null for none.
OnCommitTempTableOnCommitThe
ON COMMITaction of a temporary table; PreserveRows omits the clause.WithDataboolWhether the table is populated from the query (
WITH NO DATAwhen false).
Properties
Columns
The declared column names (resolved and optionally quoted), or null for none.
public IReadOnlyList<string>? Columns { get; init; }
Property Value
IfNotExists
Whether the statement carries IF NOT EXISTS.
public bool IfNotExists { get; init; }
Property Value
OnCommit
The ON COMMIT action of a temporary table; PreserveRows omits the clause.
public TempTableOnCommit OnCommit { get; init; }
Property Value
Table
The target table name (resolved and optionally quoted).
public string Table { get; init; }
Property Value
Temporary
Whether the target is a temporary (session-scoped) table.
public bool Temporary { get; init; }
Property Value
WithData
Whether the table is populated from the query (WITH NO DATA when false).
public bool WithData { get; init; }