CData BizTalk Adapter for PayPal 2019 - Online Help
Questions / Feedback?

sys_viewcolumns

CData BizTalk Adapter for PayPal 2019 - Build 19.0.7354

Describes the columns of the available views.

The following query returns the columns and data types for a specified view:

SELECT ColumnName, DataTypeName FROM sys_viewcolumns WHERE TableName='MyView'

Columns

Name Type Description
CatalogName String The name of the database containing the view.
SchemaName String The name of the schema containing the view.
TableName String The name of the view.
ColumnName String The name of the column.
DataTypeName String The name of the data type.
DataType Int32 An integer indicating the data type of the column. This value is determined at run time based on the environment.
Length Int32 The length in characters of the column or the numeric precision.
NumericPrecision Int32 The maximum number of digits in numeric data. The column length in characters for character and date-time data.
NumericScale Int32 The column scale or number of digits to the right of the decimal point.
IsNullable Boolean Whether the column can contain null.
Description String The column description.
Ordinal Int32 The sequence number of the column.
IsAutoIncrement String Whether the column value is assigned in fixed increments.
IsGeneratedColumn String Whether the column is generated.
IsReadOnly Boolean Whether the column is read-only.
IsKey Boolean Whether the column is a primary key.
IsHidden Boolean Whether the column is hidden.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0