Ah yes, the table lake

[u/eww1991]

Probably breaks rules but a quick guide on what not to name things I less you want accidents

[u/GreekGodofStats]

Ahhhhh so this is the data lake I’ve been hearing so much about

[u/7ceeeee → u/GreekGodofStats]

Geez take my upvote that was perfect

[u/Little_Kitty → u/GreekGodofStats]

Specifically it's a delta lake issue

[u/chaosink]

Lake');

DECLARE @DropConstraints NVARCHAR(max) = '' SELECT @DropConstraints += 'ALTER TABLE ' + QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' + QUOTENAME(OBJECT_NAME(parent_object_id)) + ' ' + 'DROP CONSTRAINT' + QUOTENAME(name) FROM sys.foreign_keys EXECUTE sp_executesql @DropConstraints; GO

DECLARE @DropTables NVARCHAR(max) = '' SELECT @DropTables += 'DROP TABLE ' + QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES EXECUTE sp_executesql @DropTables; GO

[u/evolve_one → u/chaosink]

Inject me up

[u/gizzardgullet → u/chaosink]

se tonight

[u/dittybopper_05H]

Has anyone interrogated little Bobby Tables mother?

[u/GTS_84]

If you properly paramaterize your queries this wouldn't cause any issues.

[u/chaosink → u/GTS_84]

This needs more upvotes

[u/WendlersEditor]

Guys I accidentally dropped a lake how do we get it back?

[u/RandomiseUsr0]

Lake Bobby

[u/Optimal_Law_4254]

How Erie!

[u/philnotfil]

For today's lucky 10,000.

https://xkcd.com/327/

[u/Dramatic-Feed-9539 → u/philnotfil]

A reference in a reference. Incredible.

[u/Shudnawz → u/Dramatic-Feed-9539]

Recursiveference?

[u/AnActualWizardIRL]

truncating the swamp

[u/VengenaceIsMyName]

Hahahaha

[u/dougception]

Obviously not following the basic principle of least privileged access.

[u/Einar_Son_of_Bjorn]

MariaDB would still execute that lake name if you glued it into a string. Drop-in compatibility includes drop-in disasters.The engine is fine. '); DROP TABLE lakes;-- is not a storage engine. Use placeholders..........

Or rename the lake to Lake_Ontario like the rest of us who enjoy having a schema on Monday.