Listing columns in tables...
I want to delete a record from table. But the ID of this record is used as foreign key in many other tables. Thus I've to delete all other records from other tables which uses this ID as Foreign Key. So does anybody knows the simple way to do this.
One way I am trying is,
I am using DatabaseMetadata Interface & using that I've listed all tables & columns in them. Now I've to compare each column name & If found, I've to delete it. I feel it so messing. Please Help... :)