Jd/Ops drop

Jd \| Overview \| General \| Docs \| Ops \| Admin \| Server \| Replicate \| Guide \| Technical \| Release \| License \| Support

dropcol

dropcol table col
OK if col does not exist
error if col is used in a ref

drop a ref col by name as you would any other col
get ref col names with:

jd'info ref'

drops each col of each table
releases lock
deletes filefolder
removes all rows for the folder from admin
enables subsequent createdb for same folder

files tend to be kept larger than required
data in the file can grow without having to resize/remap

dropfilesize frees up unused file space - use if a db is static

dropfilesize returns filenames, old size, new size

droptable [/reset] table

/reset preserves schema
drops rows
drops dynamic hash/unique/... cols
keeps filesize

OK if table does not exist
error if table has reference (refers to or referred by)