Training
Module
Create and manage columns within a table in Microsoft Dataverse - Training
Learn how to create and manage table columns in Dataverse.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 (for example, base-2 or 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 (for example, nvarchar for SQL Server). |
NativeDefaultExpression |
The default expression for a value of this column in the native expression language of the source (for example, 42 or newid() for SQL Server). |
Description |
The description of the column. |
Training
Module
Create and manage columns within a table in Microsoft Dataverse - Training
Learn how to create and manage table columns in Dataverse.