DELETE statement Questions

1

Delete all tables in SQL Server database?
How to delete all tables of a database in SQL Server?

Answer Question   |  November 16, 2010  8:28 AM
DELETE statement, SQL Database, SQL Server, SQL Server database, SQL tables
asked by:
220 pts.

create a procedure
i want to create a procedure it should be able to audit any change done in the database ie. drop/delete of schema tables. the procedure should be able write audited data into a remote server machine inaccessible by the system manager/dba.

Answer Question   |  March 17, 2010  6:24 AM
DELETE statement, DROP, SQL Developer
asked by:
5 pts.

how delete 12,33,200 rows in oracle table
how delete 12,33,200 rows in oracle table

Answer Question   |  May 3, 2012  9:04 AM
DELETE statement, Oracle Table
asked by:
10 pts.

Delete OLD files from Table not having date or timestamp
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn’t have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn’t have creation date field. So, like [...]

Answer Question   |  July 30, 2009  10:46 AM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL
asked by:
45 pts.

Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?

Answer Question   |  June 4, 2009  9:01 AM
DELETE statement, SQL, SQL variables, SQLRPG
asked by:
5 pts.

Multiple DELETE From Statements in Query Manager
How do I enter more than one Delete from …… where .. Statement from within Query Manager?

Answer Question   |  August 25, 2009  3:41 PM
DELETE statement, IBM DB2 Query Management Facility, Query Manager
asked by:
10 pts.

Oracle – Deleting a row from a complex view
why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

Answer Question   |  January 23, 2009  3:53 AM
DELETE statement, Oracle administration, Oracle Complex View, Oracle development
asked by:
10 pts.

Unable to use delete statement in SQLRPG
Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

Answer Question   |  January 22, 2009  11:43 AM
DELETE statement, Embedded SQL, RPG, SQL, SQLRPG
asked by:
0 pts.

Delete query
Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not [...]

Answer Question   |  April 18, 2008  5:53 PM
Access 2000, Database, DELETE statement
asked by:
15 pts.

Delete ODS request via Process Chain
Hello Guru: How can I delete all requests in ODS via Process chain; except last day of the week and last they of the month I do not want to delete. thanks

Answer Question   |  December 6, 2007  8:50 PM
DELETE statement, ODS (Operational Data Store), Process chain
asked by:
20 pts.

1