Metadata Structure (FireDAC)

From RAD Studio
Jump to: navigation, search

Go Up to Working with Metadata (FireDAC)


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.

See Also