EnumColumns 方法
Enumerates a list of columns that can be accessed on the linked server.
命名空間： Microsoft.SqlServer.Management.Smo
組件： Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Function EnumColumns As DataTable
'用途
Dim instance As LinkedServer
Dim returnValue As DataTable
returnValue = instance.EnumColumns()
public DataTable EnumColumns()
public:
DataTable^ EnumColumns()
member EnumColumns : unit -> DataTable
public function EnumColumns() : DataTable
傳回值
型別：System.Data. . :: . .DataTable
A DataTable object value that contains a list of tables that can be accessed on the linked server. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
|---|---|---|
COLUMN_SIZE |
The number of significant digits in the column. The return value for the PRECISION column is in base 10. |
|
BUFFER_LENGTH |
The transfer size of the data to and from the column. |
|
DECIMAL_DIGITS |
The number of digits to the right of the decimal point. |
|
NUM_PREC_RADIX |
The base for numeric data types. |
|
NULLABLE |
The nullability of the column. 1 = NULL is possible. 0 = NOT NULL. |
|
REMARKS |
This field always returns NULL. |
|
COLUMN_DEF |
The default value of the column. |
|
SQL_DATA_TYPE |
The value of the SQL data type as it appears in the TYPE field of the descriptor. This column is the same as the DATA_TYPE column, except for the DateTime and ISO interval data types. This column always returns a value. |
|
SQL_DATETIME_SUB |
The subtype code for DateTime and ISO interval data types. For other data types, this column returns NULL. |
|
CHAR_OCTET_LENGTH |
The maximum length in bytes of a character or integer data type column. For all other data types, this column returns NULL. |
|
ORDINAL_POSITION |
The ordinal position of the column in the table. The first column in the table is 1. This column always returns a value. |
|
IS_NULLABLE |
The nullability of the column in the table. ISO rules are followed to determine nullability. An ISO SQL-compliant DBMS cannot return an empty string. YES = Column can include NULLS. NO = Column cannot include NULLS. This column returns a zero-length string if nullability is unknown. The value returned for this column is different from the value returned for the NULLABLE column. |
|
SS_DATA_TYPE |
The ordinal position of the column in the table. The first column in the table is 1. This column always returns a value. |