Ошибка OLE DB или ODBC : [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 8
[; HY000.

При обработке таблицы "ACTIONS" произошла ошибка.

Текущая операция отменена, поскольку другая операция в данной транзакции завершилась ошибкой.

select cast( '' as varchar(255)) as table_cat,
	cast (tbl.rdb$owner_name as varchar(31)) as table_schem,
	cast (rfr.rdb$relation_name as varchar(31)) as table_name,
	cast (rfr.rdb$field_name as varchar(31)) as column_name,
	fld.rdb$field_type as data_type,
	cast (fld.rdb$field_name as varchar(31)) as type_name,
	cast (fld.rdb$collation_id as integer) as column_size,
	cast (fld.rdb$character_set_id as integer) as buffer_length,
	cast (fld.rdb$field_scale as smallint) as decimal_digits,
	fld.rdb$field_scale as num_prec_radix,
	rfr.rdb$null_flag as nullable,
	cast (NULL as char(10)) as remarks,
	cast (rfr.rdb$field_name as varchar(512)) as column_def,
	fld.rdb$field_type as SQL_DATA_TYPE,
	fld.rdb$field_sub_type as SQL_DATETIME_SUB,
	10 as CHAR_OCTET_LENGTH,
	10 as ordinal_position,
	cast ('YES' as varchar(3)) as IS_NULLABLE,
	fld.rdb$character_length as char_len,
	fld.rdb$default_source as f_def_source,
	fld.rdb$dimensions as array_dim,
	fld.rdb$null_flag as null_flag,
	rfr.rdb$field_position as column_position,
	fld.rdb$field_length as column_length,
	fld.rdb$field_precision as column_precision,
	rfr.rdb$default_source as column_def
from rdb$relation_fields rfr, rdb$fields fld, rdb$relations tbl
where rfr.rdb$field_source = fld.rdb$field_name
	and rfr.rdb$relation_name = tbl.rdb$relation_name
 and  rfr.rdb$relation_name = 'CARDTAB_PLACE'
 order by rfr.rdb$relation_name, rfr.rdb$field_position

select cast('' as varchar(7)) as table_cat,
	cast(rl.rdb$owner_name as varchar(31)) as table_schem,
	cast(rl.rdb$relation_name as varchar(31)) as table_name,
	cast(0 as smallint) as non_unique,
	cast(NULL as varchar(31)) as index_qualifier,
	cast(NULL as varchar(31)) index_name,
	cast(0 as smallint) as index_type,
	cast(NULL as smallint) as ordinal_position,
	cast(NULL as varchar(31)) as column_name,
	cast(NULL as char CHARACTER SET NONE) as asc_or_desc,
	cast(NULL as integer) as cardinality,
	cast(NULL as integer) as index_pages,
	cast(NULL as varchar(31)) as filter_condition,
	cast(NULL as smallint) as index_type,
	cast(NULL as varchar(31)) as constraint_type
from rdb$relations rl
 where  rl.rdb$relation_name = 'CARDPARAMS'
	union
select cast('' as varchar(7)) as table_cat,
	cast(tbl.rdb$owner_name as varchar(31)) as table_schem,
	cast(idx.rdb$relation_name as varchar(31)) as table_name,
	cast((1-idx.rdb$unique_flag) as smallint) as non_unique,
	cast(idx.rdb$index_name as varchar(31)) as index_qualifier,
	cast(idx.rdb$index_name as varchar(31)) as index_name,
	cast(3 as smallint) as index_type,
	cast(seg.rdb$field_position as smallint) as ordinal_position,
	cast(coalesce(seg.rdb$field_name,
substring(idx.rdb$expression_source from 1 for 31)) as varchar(31)) as column_name,
	cast(NULL as char CHARACTER SET NONE) as asc_or_desc,
	cast((case when idx.rdb$statistics = 0 then 0 else
1/idx.rdb$statistics end) as integer) as cardinality,
	cast(NULL as integer) as index_pages,
	cast(NULL as varchar(31)) as filter_condition,
	cast(idx.rdb$index_type as smallint) as index_type,
	cast(relc.rdb$constraint_type as varchar(31)) as constraint_type
from rdb$indices idx
	left join rdb$relations tbl on tbl.rdb$relation_name = idx.rdb$relation_name
	left join rdb$index_segments seg on idx.rdb$index_name = seg.rdb$index_name
	left join rdb$relation_constraints relc on ( relc.rdb$index_name = idx.rdb$index_name
			and relc.rdb$relation_name = idx.rdb$relation_name )
 where  idx.rdb$relation_name = 'CARDPARAMS'
 order by 4, 7, 15, 5, 6, 8select cast('' as varchar(7)) as table_cat,
	cast(rl.rdb$owner_name as varchar(31)) as table_schem,
	cast(rl.rdb$relation_name as varchar(31)) as table_name,
	cast(0 as smallint) as non_unique,
	cast(NULL as varchar(31)) as index_qualifier,
	cast(NULL as varchar(31)) index_name,
	cast(0 as smallint) as index_type,
	cast(NULL as smallint) as ordinal_position,
	cast(NULL as varchar(31)) as column_name,
	cast(NULL as char CHARACTER SET NONE) as asc_or_desc,
	cast(NULL as integer) as cardinality,
	cast(NULL as integer) as index_pages,
	cast(NULL as varchar(31)) as filter_condition,
	cast(NULL as smallint) as index_type,
	cast(NULL as varchar(31)) as constraint_type
from rdb$relations rl
 where  rl.rdb$relation_name = 'CARDPARAMS'
	union
select cast('' as varchar(7)) as table_cat,
	cast(tbl.rdb$owner_name as varchar(31)) as table_schem,
	cast(idx.rdb$relation_name as varchar(31)) as table_name,
	cast((1-idx.rdb$unique_flag) as smallint) as non_unique,
	cast(idx.rdb$index_name as varchar(31)) as index_qualifier,
	cast(idx.rdb$index_name as varchar(31)) as index_name,
	cast(3 as smallint) as index_type,
	cast(seg.rdb$field_position as smallint) as ordinal_position,
	cast(coalesce(seg.rdb$field_name,
substring(idx.rdb$expression_source from 1 for 31)) as varchar(31)) as column_name,
	cast(NULL as char CHARACTER SET NONE) as asc_or_desc,
	cast((case when idx.rdb$statistics = 0 then 0 else
1/idx.rdb$statistics end) as integer) as cardinality,
	cast(NULL as integer) as index_pages,
	cast(NULL as varchar(31)) as filter_condition,
	cast(idx.rdb$index_type as smallint) as index_type,
	cast(relc.rdb$constraint_type as varchar(31)) as constraint_type
from rdb$indices idx
	left join rdb$relations tbl on tbl.rdb$relation_name = idx.rdb$relation_name
	left join rdb$index_segments seg on idx.rdb$index_name = seg.rdb$index_name
	left join rdb$relation_constraints relc on ( relc.rdb$index_name = idx.rdb$index_name
			and relc.rdb$relation_name = idx.rdb$relation_name )
 where  idx.rdb$relation_name = 'CARDPARAMS'
 order by 4, 7, 15, 5, 6, 8