From: Sasha Pachev Date: March 11 1999 9:46pm Subject: Re: sort of defragmentation? List-Archive: http://lists.mysql.com/mysql/44 Message-Id: <36E839AA.51999A52@direct1.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Charles Kirby wrote: > > Ah, that's what I wanted to hear. But surely, if Mysql doesn't support > foreign keys and triggers, what orphans could possibly result from > deleting a line in the existing mysql? Other than anything you knowingly > set up yourself to specifically have a relationship from one table to > another, is any relationship built-in with the keystone database? > > Thanks, ck > The tables are completely independent as far as the database is concerned. You can delete one completely, and the others will continue to exist peacefully, with the exception of the queries that reference the deleted table of course. So you have to do the work yourself. -- Sasha Pachev http://www.sashanet.com/ (home) http://www.direct1.com/ (work)