On 11/11/22 17:18, Rui DeSousa wrote:
Or just read the documentation for the current version (I seem to recall it used to be non-transactional, maybe...doesn't matter now).
In a lot of other databases DDL is not transactional and truncate is DDL — most likely confusing it with another RDBMS systems.
The first two RDBMS I dealt with had transactional DDL. It's...
natural, given that table definitions reside in a system catalog that's just a bunch of tables... I was shocked to see how Oracle does it (and that they don't have integers).
--
Angular momentum makes the world go 'round.