Returns a table describing the columns of {0}. Each row in the table describes the properties of a column of {0}: Column ...

Returns a table describing the columns of {0}.
Each row in the table describes the properties of a column of {0}:


  

    
Column Name
    
Description
  
  

    
Name
    
The name of the column.
  
  

    
Position
    
The 0-based position of the column in {0}.
  
  

    
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.
  
  

    
nbsp;
    
 
  
  

    
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.