TRUNCATE also fails if you use foreign key constraints, regardless of whether they are violated.

I fully agree that people should not be allowed to create datbases willy-nilly.

If developers go creating databases then

• who is going to put the databases onto a backup schedule.
• Who is going to ensure that the correct database options are set.
• Who is going to check server capacity i.e. Mr Developer decides he needs a 10Gb database.

========================

He was not wholly unware of the potential lack of insignificance.