delete « Table « Java Database Q&A





1. Delete a row by comparing two tables without frontend screen    coderanch.com

I am trying to compare two table data and if we happpen to delete a row in first table it has to delete in the second table also. And my program has to be bidirectional also. I mean it has to check from table 1 to 2 or 2 to 1 according to the requirement. Please tell me how to write ...

2. cant delete frrom table    coderanch.com

Bear already asked why you would expect and UPDATE to delete/remove a record from a table. Am I missing something? After executing your statement the record will still be in the table. You still need a DELETE statement to remove it from the table. If you are new to SQL and/or relational databases in general, you will need a tutorial.

4. How to delete a record from a table without a primary key    coderanch.com

Originally posted by Jeanne Boyarsky: Solomon, How would you uniquely identify the record(s) to delete? Try describing this in words first. It can involve one or more columns. Then you can use SQL to delete. Welcome to JavaRanch. My problem is,I have 11 attributes in a table.There are 4 foriegn keys,no pk's.I have to delete a set of records(more than one ...

5. question about deleting a table column    coderanch.com

Hi, guys: I have DB2/NT 7.2.3 on my Win2000. I am trying to delete a column from a table like this: ALTER table mytable drop column mycolumn decimal(15) it seems I cannot do it. Is this because of my version or OS? Os there any way around this? thanks a lot [ January 15, 2005: Message edited by: rick collette ] ...

6. how to find child table names that need to be deleted?    coderanch.com

hello, i have a master table and there are a few child tables. i need to delete a record in the master table, but i dont want to delete dependent child records by cascading. i want the program to catch JDBC exception and then to display an alert of asking users to delete child records manually. i dont want "soft delete" ...

7. Deleting from multiple Tables    coderanch.com

I don't know anything about Access, but in general there are a few different approaches. In many databases, when there is a parent-child relationship between two tables, enforced by a Foreign Key constraint, the constraint can be specified with something like "ON DELETE CASCADE"; then when a record in the parent table is deleted, the database will automatically delete any dependent ...

8. Delete from multiple tables.    coderanch.com

Problem is this: I have to delete from TableA,B,C. Table A's PK is an FK in Table B and Table C. I can do this as three DELETE statements. Delete from table b; delete from table c; and finally, delete from table A. Is this a good approach. Is there a better approach to achieve this ? Thanks





12. delete a row from table in db    forums.oracle.com