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
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
how delete 12,33,200 rows in oracle table
Answer Question | May 3, 2012 9:04 AM
DELETE statement, Oracle Table
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
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
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
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
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
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
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