Any one know, why DML command rollback and DDL command can't?
Loading
Any one know, why DML command rollback and DDL command can't?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Rajanikant HawaldarPosted Oct 7, 2022, 5:22 AM
Because DDL commands are Auto-commit by default.
They will not be sent/commited to database directly until an explicit "commit" command is issued. As they are just manipulation commands. Whereas DDL commnads directly work on data defimitions i.e on structures of db.
Muhammad Imran AnsariPosted Oct 6, 2022, 6:17 PM
DML is the Data Manipulation Language, which means they are the statements you use to manipulate the data in the database. Commands are not auto-committed and you can roolback the the changes which you made. So, It is possible to roll back the operation before commit.
DDL is the Data Definition Language helps you to define the database structure or schema. DDL commands help you to create the structure of the database and the other database objects. Its commands are auto-committed so, the changes are saved in the database permanently.