Hi,
Try execute block this will be "one" statement if this is your point about
"one"
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: "Jiří Činčura" <j...@cincura.net>
Do: "For discussion among Firebird Developers"
<firebird-devel@lists.sourceforge.net>
Temat: [Firebird-devel] Adding/removing NOT NULL from column in one DDL
Data: czw., lis 6, 2014 14:22
> This will be available in Firebird 3.
I know, but that's not what I asked for.
I'm looking for "some" way. I was trying:
alter table aaa_test drop constraint
(
select rc.rdb$constraint_name
from rdb$relation_constraints rc
join rdb$check_constraints cc
on rc.rdb$constraint_name = cc.rdb$constraint_name
where rc.rdb$constraint_type = 'NOT NULL'
and rc.rdb$relation_name = 'AAA_TEST'
and cc.rdb$trigger_name = 'FOO'
)
but that does not work, obviously. Maybe there's some syntax hack I haven't
tested, yet.
--
Mgr. Jiří Činčura
Independent IT Specialist
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
