X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=sql%2Ftable.lisp;fp=sql%2Ftable.lisp;h=52b5c1a155143c3b96a51228b9bfe4d504f2bc31;hp=4fb91685eff5e690b08ca954e33d3bab4c9d4f7b;hb=db9892632e6eb7869aea7a94c16b523a82de1501;hpb=09ad7f1b964e6c58de9bd6c52b9b9b8a0ad9273d diff --git a/sql/table.lisp b/sql/table.lisp index 4fb9168..52b5c1a 100644 --- a/sql/table.lisp +++ b/sql/table.lisp @@ -185,6 +185,15 @@ specification of a table to drop the index from." OWNER is a string, this denotes a username and only indexs owned by OWNER are considered. Index names are returned as a list of strings." (database-list-indexes database :owner owner)) + +(defun list-table-indexes (table &key (owner nil) + (database *default-database*)) + "List all indexes in DATABASE for a TABLE, which defaults to +*default-database*. If OWNER is :all , all indexs are considered. If +OWNER is a string, this denotes a username and only indexs owned by +OWNER are considered. Index names are returned as a list of strings." + (database-list-table-indexes (database-identifier table) + database :owner owner)) (defun index-exists-p (name &key (owner nil) (database *default-database*)) "Test for existence of an index called NAME in DATABASE which