Table.Schema

Syntax

Table.Schema(table as table) as table

About

Returns a table describing the columns of `table`.

Each row in the table describes the properties of a column of `table`:

>
Column Name Description
`Name` The name of the column.
`Position` The 0-based position of the column in `table`.
`TypeName` The name of the type of the column.
`Kind` The kind of the type of the column.
`IsNullable` Whether the column can contain `null` values.
`NumericPrecisionBase` The numeric base (e.g. base-2, base-10) of the `NumericPrecision` and `NumericScale` fields.
`NumericPrecision` The precision of a numeric column in the base specified by `NumericPrecisionBase`. This is the maximum number of digits that can be represented by a value of this type (including fractional digits).
`NumericScale` The scale of a numeric column in the base specified by `NumericPrecisionBase`. This is the number of digits in the fractional part of a value of this type. A value of `0` indicates a fixed scale with no fractional digits. A value of `null` indicates the scale is not known (either because it is floating or not defined).
`DateTimePrecision` The maximum number of fractional digits supported in the seconds portion of a date or time value.
`MaxLength` The maximum number of characters permitted in a `text` column, or the maximum number of bytes permitted in a `binary` column.
`IsVariableLength` Indicates whether this column can vary in length (up to `MaxLength`) or if it is of fixed size.
`NativeTypeName` The name of the type of the column in the native type system of the source (e.g. `nvarchar` for SQL Server).
`NativeDefaultExpression` The default expression for a value of this column in the native expression language of the source (e.g. `42` or `newid()` for SQL Server).
`Description` The description of the column.