DROP [IF EXISTS] ...
---------------------
Key: CORE-3863
URL: http://tracker.firebirdsql.org/browse/CORE-3863
Project: Firebird Core
Issue Type: New Feature
Components: Engine
Reporter: eXandr
Priority: Minor
It should be possible to determine not cause an error when deleting an object
that does not exist
Something like that:
execute statement 'ALTER TABLE SOME_TABLE DROP [IF EXISTS] SOME_FIELD'; -- no
raise error if field SOME_FIELD is not exist
or
execute statement 'DROP INDEX IDX1 [IF EXISTS]'; -- no raise error if index
IDX1 is not exist
Workaround for now is:
begin
execute statement 'ALTER TABLE SOME_TABLE DROP SOME_FIELD';
when any do
begin
end
end
But this solution hides any error that is very bad. Another solution is to
access the system tables, but it requires more code and can add even more
errors.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
