• Delete all tables in SQL Server database?

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

    Prcvjr220 pointsBadges:
  • Create a procedure to audit changes done in a database

    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.

    Shwetamishra5 pointsBadges:
  • how delete 12,33,200 rows in oracle table

    how delete 12,33,200 rows in oracle table

    Shindetanaji10 pointsBadges:
  • Multiple DELETE From Statements in Query Manager

    How do I enter more than one Delete from ...... where .. Statement from within Query Manager?

    Pb5410 pointsBadges:
  • 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 RRN does DB2 have any...

    RJES45 pointsBadges:
  • Delete variable file in SQLRPG

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

    Samuele5 pointsBadges:
  • 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

    Avej10 pointsBadges:
  • 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.

    0 pointsBadges:
  • 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 the last one....

    Samotek15 pointsBadges:
  • 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

    SAPFAQ200520 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.