Metadata Structure (FireDAC)
Go Up to Working with Metadata (FireDAC)
Contents
- 1 Description
- 1.1 Catalog List (mkCatalogs)
- 1.2 Schema List (mkSchemas)
- 1.3 Table List (mkTables)
- 1.4 Table Field List (mkTableFields) and Table Type Field List (mkTableTypeFields)
- 1.5 Table Indexes (mkIndexes) and Primary Key List (mkPrimaryKey)
- 1.6 Table Index Fields (mkIndexFields) and Primary Key Fields List (mkPrimaryKeyFields)
- 1.7 Table Foreign Key List (mkForeignKeys)
- 1.8 Table Foreign Key Fields List (mkForeignKeyFields)
- 1.9 Packages List (mkPackages)
- 1.10 Stored Procedures List (mkProcs)
- 1.11 Stored Procedure Arguments List (mkProcArgs)
- 1.12 Generators / Sequences List (mkGenerators)
- 2 See Also
Description
Catalog List (mkCatalogs)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
Schema List (mkSchemas)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
Table List (mkTables)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
TABLE_TYPE | dtInt32 | Table type. Cast value to FireDAC.Phys.Intf.TFDPhysTableKind. |
Table Field List (mkTableFields) and Table Type Field List (mkTableTypeFields)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
COLUMN_NAME | dtWideString | Column name. |
COLUMN_POSITION | dtInt32 | Column position. |
COLUMN_DATATYPE | dtInt32 | Column data type. Cast value to FireDAC.Stan.Intf.TFDDataType. |
COLUMN_TYPENAME | dtWideString | DBMS native column type name. |
COLUMN_ATTRIBUTES | dtUInt32 | Column attributes. Cast value to FireDAC.Stan.Intf.TFDDataAttributes. |
COLUMN_PRECISION | dtInt32 | Numeric and date/time column precision. |
COLUMN_SCALE | dtInt32 | Numeric and date/time column scale. |
COLUMN_LENGTH | dtInt32 | Character and byte string column length. |
Note: To cast COLUMN_ATTRIBUTES column value to TFDDataAttributes use the code:
var
i: Integer;
...
i := FDMetaInfoQuery1.FieldByName('COLUMN_ATTRIBUTES').AsInteger;
eAttrs := TFDDataAttributes(Pointer(@i)^);
Table Indexes (mkIndexes) and Primary Key List (mkPrimaryKey)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
INDEX_NAME | dtWideString | Index name. |
CONSTRAINT_NAME | dtWideString | Primary key constraint name. |
INDEX_TYPE | dtInt32 | Index type. Cast value to FireDAC.Phys.Intf.TFDPhysIndexKind. |
Table Index Fields (mkIndexFields) and Primary Key Fields List (mkPrimaryKeyFields)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
INDEX_NAME | dtWideString | Index name. |
COLUMN_NAME | dtWideString | Indexed column name. |
COLUMN_POSITION | dtInt32 | Column position in the index. |
SORT_ORDER | dtWideString | Column sort order. 'A' - ascending. 'D' - descending. |
FILTER | dtWideString | Optional column filter expression. |
Table Foreign Key List (mkForeignKeys)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
FKEY_NAME | dtWideString | Foreign key constraint name. |
PKEY_CATALOG_NAME | dtWideString | Referenced table catalog name. |
PKEY_SCHEMA_NAME | dtWideString | Referenced table schema name. |
PKEY_TABLE_NAME | dtWideString | Referenced table name. |
DELETE_RULE | dtInt32 | Foreign key delete rule. Cast value to FireDAC.Phys.Intf.TFDPhysCascadeRuleKind. |
UPDATE_RULE | dtInt32 | Foreign key update rule. Cast value to FireDAC.Phys.Intf.TFDPhysCascadeRuleKind. |
Table Foreign Key Fields List (mkForeignKeyFields)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
TABLE_NAME | dtWideString | Table name. |
FKEY_NAME | dtWideString | Foreign key constraint name. |
COLUMN_NAME | dtWideString | Column name. |
PKEY_COLUMN_NAME | dtWideString | Referenced table column name. |
COLUMN_POSITION | dtInt32 | Column position in constraint. |
Packages List (mkPackages)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
PACKAGE_NAME | dtWideString | Package name. |
PACKAGE_SCOPE | dtInt32 | Package scope. Cast value to FireDAC.Phys.Intf.TFDPhysObjectScope. |
Stored Procedures List (mkProcs)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
PACK_NAME | dtWideString | Optional package name. |
PROC_NAME | dtWideString | Procedure name. |
OVERLOAD | dtInt32 | Procedure name. |
PROC_TYPE | dtInt32 | Procedure type. Cast value to FireDAC.Phys.Intf.TFDPhysProcedureKind. |
PROC_SCOPE | dtInt32 | Procedure scope. Cast value to FireDAC.Phys.Intf.TFDPhysObjectScope. |
IN_PARAMS | dtInt32 | Number of input parameters. |
OUT_PARAMS | dtInt32 | Number of output parameters. |
Stored Procedure Arguments List (mkProcArgs)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtAnsiString | Catalog name. |
SCHEMA_NAME | dtAnsiString | Schema name. |
PACK_NAME | dtAnsiString | Optional package name. |
PROC_NAME | dtAnsiString | Procedure name. |
OVERLOAD | dtInt32 | Overloaded procedure number. |
PARAM_NAME | dtAnsiString | Parameter name. |
PARAM_POSITION | dtInt32 | Parameter position. |
PARAM_TYPE | dtInt32 | Parameter type. Cast value to Data.DB.TParamType. |
PARAM_DATATYPE | dtInt32 | Parameter data type. Cast value to FireDAC.Stan.Intf.TFDDataType. |
PARAM_TYPENAME | dtAnsiString | DBMS native parameter data type name. |
PARAM_ATTRIBUTES | dtUInt32 | Parameter attributes. Cast value to FireDAC.Stan.Intf.TFDDataAttributes. |
PARAM_PRECISION | dtInt32 | Numeric and date/time parameter precision. |
PARAM_SCALE | dtInt32 | Numeric and date/time parameter scale. |
PARAM_LENGTH | dtInt32 | Character and byte string parameter length. |
Generators / Sequences List (mkGenerators)
Column name | Data type | Description |
---|---|---|
RECNO | dtInt32 | |
CATALOG_NAME | dtWideString | Catalog name. |
SCHEMA_NAME | dtWideString | Schema name. |
GENERATOR_NAME | dtWideString | Generator / sequence name. |
GENERATOR_SCOPE | dtInt32 | Generator / sequence scope. Cast value to FireDAC.Phys.Intf.TFDPhysObjectScope. |