X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=sql%2Ffddl.lisp;h=2c28ab2bc212884195c2059cc141cbf6d89f3023;hb=6e49d313475d42d2ef7b4eea626f2d7da902d09e;hp=19dfea994127c2b7c0a0f78cd9721164fa4b88b7;hpb=fdc28505b82da26cc8142964cb8ae40cdc8bfdfc;p=clsql.git diff --git a/sql/fddl.lisp b/sql/fddl.lisp index 19dfea9..2c28ab2 100644 --- a/sql/fddl.lisp +++ b/sql/fddl.lisp @@ -111,6 +111,13 @@ is a string denoting a user name, only tables owned by OWNER are listed. If OWNER is :all then all tables are listed." (database-list-tables database :owner owner)) +(defmethod %table-exists-p (name (database T) &key owner ) + (unless database (setf database *default-database*)) + (let ((name (database-identifier name database)) + (tables (list-tables :owner owner :database database))) + (when (member name tables :test #'string-equal) + t))) + (defun table-exists-p (name &key (owner nil) (database *default-database*)) "Tests for the existence of an SQL table called NAME in DATABASE which defaults to *DEFAULT-DATABASE*. OWNER is nil by default @@ -118,10 +125,7 @@ which means that only tables owned by users are examined. If OWNER is a string denoting a user name, only tables owned by OWNER are examined. If OWNER is :all then all tables are examined." - (when (member (database-identifier name database) - (list-tables :owner owner :database database) - :test #'string-equal) - t)) + (%table-exists-p name database :owner owner)) ;; Views