SQL queries
Posted: Tue Apr 29, 2014 8:28 pmHow do I get the number of rows got deleted in all the table under the ON DELETE CASCADE rule?
I know SQLERRD(3) gives the total number of rows delted, but I want to know the deleted counts against every table. In other words audit of tables and number of rows deleted.
I know SQLERRD(3) gives the total number of rows delted, but I want to know the deleted counts against every table. In other words audit of tables and number of rows deleted.