1

I am learning SQL. I am trying to get all savepoint list. So which command is used to get all savepoint list in a database/table? I have tried SHOW SAVEPOINTS but it's not working.

MdFarzan
  • 320
  • 4
  • 11

1 Answers1

2

savepoints only exist during a transaction, within that transaction. As far as I know, there is no way to list them; since you are in the middle of the code that created them, you are supposed to know what they are named already.

ysth
  • 96,171
  • 6
  • 121
  • 214