|
Hello!
Earlier we can get index SortOrder
----------
SELECT
null AS TABLE_CATALOG, null AS TABLE_SCHEMA, idx.rdb$relation_name AS TABLE_NAME, idx.rdb$index_name AS INDEX_NAME, idx.rdb$index_type AS INDEX_TYPE, /// <- this filed seg.rdb$field_name AS COLUMN_NAME, seg.rdb$field_position AS ORDINAL_POSITION, idx.rdb$index_inactive AS IS_INACTIVE, idx.rdb$system_flag AS IS_SYSTEM_INDEX, idx.rdb$unique_flag AS IS_UNIQUE, idx.rdb$statistics AS INDEX_STATISTICS, idx.rdb$description AS DESCRIPTION FROM rdb$indices idx left join rdb$index_segments seg ON idx.rdb$index_name = seg.rdb$index_name ----------
now this field
removed.
|
- [Firebird-net-provider] FbSchema Indexes sunika
- Re: [Firebird-net-provider] FbSchema Indexes Carlos Guzmán Álvarez
