X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-fddl.xml;h=422134396c9f6f0c3308afee632dac50eb1d5a28;hb=f7a356bb4c11d062eeeb5d4aaf4e187a3cb15a27;hp=5d542ded1ffdf0b8b92969d71c67d9a63bc108c5;hpb=fdd069770e32d0cfa4b66d6e5cfd4540197660ba;p=clsql.git diff --git a/doc/ref-fddl.xml b/doc/ref-fddl.xml index 5d542de..4221343 100644 --- a/doc/ref-fddl.xml +++ b/doc/ref-fddl.xml @@ -2506,4 +2506,101 @@ + + + TRUNCATE-DATABASE + + + Function TRUNCATE-DATABASE + Drop all tables, views, indexes and sequences in a database. + Function + + + Syntax + + truncate-database &key database => + + + Arguments and Values + + + database + + A + database + object. This will default to the value + of *default-database*. + + + + + + Description + + Drop all tables, views, indexes and sequences in + database which defaults to + *default-database*. + + + + Examples + +(list-tables) +=> ("type_table" "type_bigint" "employee" "company" "addr" "ea_join" "big") +(list-indexes) +=> ("employeepk" "companypk" "addrpk") +(list-views) +=> ("lenins_group") +(list-sequences) +=> ("foo" "bar") +(truncate-database) +=> +(list-tables) +=> NIL +(list-indexes) +=> NIL +(list-views) +=> NIL +(list-sequences) +=> NIL + + + + Side Effects + + Modifications are made to the underlying database. + + + + Affected by + + None. + + + + Exceptional Situations + + Signals an error of type sql-database-error if + database is not a database object. + + + + See Also + + + drop-table + drop-view + drop-index + drop-sequence + + + + + Notes + + truncate-database is a &clsql; extension. + + + +