Searching an entire database

DragonHighLord

How do you do a search on entire db so that you can delete a specific entry from each table?

In other words, I have many tables that have user names in the and if I want to delete a specific user, how do I search a whole db without having to code in

"DELETE from table1 where user=xxx"

for each table there is.

laserlight

Just have 1 table with the specific user.

The other tables will use reference that table by using keys.

DragonHighLord

Would still have the same problem, I would then have to search all the tables and delete the entries with that ID

laserlight

Depends on how you implement it.

Remember, files on your hard drive are usually marked as deleted (i.e. logical deletion) rather than physically deleted.

You can do the same for your system.

But if you wish to actually delete any and all entries related to that user, then yes, you must go through all tables that reference the user (or rather user id).

Frankly you dont need to search through all tables, since during planning you should know which tables do what.

DragonHighLord

Yeah, that is true.. I know exactly which ones it is, I just wandering if there was like a one line command that would search them all automatically rather than having a series of delete commands for each table