*** 95,100 **** --- 95,102 ---- a '.' in them. this would fake schemas good enough for me. right now it doesnt seem to allow it. + _:::::: You can fake this syntax if you split the "schemas" off into seperate files, then do an ATTACH DATABASE blorg.db AS blorg; SELECT zipcode FROM blorg.address; + *: TRUNCATE (MySQL, Postgresql and Oracle have it... but I dont know if this is a standard command) - _SQLite does this automatically when you do a DELETE without a WHERE clause. You can use also VACUUM command_