1. Delete a row by comparing two tables without frontend screen coderanch.comI 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.comBear 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.comOriginally 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.comHi, 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.comhello, 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.comI 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.comProblem 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 |
11. Java DB - Delete all records in a table. coderanch.com |
12. delete a row from table in db forums.oracle.com |