Table.Schema
Table.Schema(table as table) as table
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. |
Show: