[Koha-bugs] [Bug 7902] Adding Function to Check for Existence of Tables

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7902

--- Comment #3 from Chris Nighswonger <cnighswonger at foundations.edu> ---
(In reply to comment #2)
> QA Comment, 
> 
> Why don't you simply use the following syntax:
>   DROP TABLE IF NOT EXISTS $tablename
> 
> It is supported by mysql and postgresql
> 
> http://dev.mysql.com/doc/refman/5.1/en/drop-table.html
> http://www.postgresql.org/docs/8.2/static/sql-droptable.html

The included syntax is truly DB agnostic, whereas some DBs may implement EXISTS
differently.

-- 
You are receiving this mail because:
You are watching all bug changes.