information_schema
は、CData Virtuality Server で設定されたデータソース内のすべてのテーブル、ビュー、カラムに関する情報を提供する読み取り専用のビュー の ANSI 標準セットです。
Columns
Columns
ビューには、CData Virtuality Server で構成されたデータソースのすべてのテーブルとビュー列 に関する情報が含まれています。可視性はUserのアクセスPermissionによって決まります。
To view the full table, click the expand button in its top right corner
Column name | Column data type | Column description |
---|---|---|
| integer | The declared maximum length for data types where applicable; null for all other data types or if no maximum length was declared |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Default expression of the column |
| string | Name of the column |
| integer | If the data type identifies a date, time, timestamp, or interval type, this column contains the (declared or implicit) fractional seconds precision of the type for this column, that is, the number of decimal digits maintained following the decimal point in the seconds value. For all other data types, this column is null |
| string |
|
| string |
|
| integer | If the data type identifies a numeric type, this column contains the (declared or implicit) precision of the type for this column |
| integer | If the data type identifies a numeric type, this column indicates in which base the values in the columns |
| integer | If the data type identifies an exact numeric type, this column contains the (declared or implicit) scale of the type for this column. The scale indicates the number of significant digits to the right of the decimal point |
| integer | Ordinal position of the column within the table (count starts at 1) |
| string | Name of the virtual database containing the table/view |
| string | Name of the table/view |
| string | Name of the schema containing the table/view |
| string | Name of the column data type |
Tables
Tables
ビューには、CData Virtuality Server で構成されたすべてのテーブルとビュー が含まれます。 Visibility はユーザーのアクセス権限によって決定されます。
Column name | Column data type | Column description |
---|---|---|
| string | Name of the virtual database containing the table/view |
| string | Name of the table/view |
| string | Name of the schema containing the table/view |
| string | Type of the table: |
Views
Views
ビューには、CData Virtuality Server で構成されたすべてのビュー が含まれます。 可視性はユーザーのアクセス Permission によって決定されます。
Column name | Column data type | Column description |
---|---|---|
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | Applies to feature not available in CData Virtuality |
| string | |
| string | Name of the virtual database containing the view |
| string | Name of the view |
| string | Name of the schema containing the view |
| string | Query expression defining the view |