Why have emojis?

Dildas

Jan 15, 2019, 21:04 pm

SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
Site Admin
admin

Jan 15, 2019, 21:05 pm

:rofl:
Ten percent of nothin' is... let me do the math here... nothin' into nothin'... carry the nothin'...
Dildas

Jan 15, 2019, 21:05 pm

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Site Admin
admin

Jan 15, 2019, 21:15 pm

I wish you luck. :) But you'll have to try a bit harder if you want to find a spot where you can actually drop a table.
Ten percent of nothin' is... let me do the math here... nothin' into nothin'... carry the nothin'...
JupiterStarWarrior
Location: Oklahoma City, Oklahoma

Jan 16, 2019, 02:42 am

We can try *flipping* the table...?
Watch me every Wednesday at 7pm Central at https://Twitch.tv/JupiterStarWarrior