Page 1 of 1

Why have emojis?

Posted: Jan 15, 2019, 21:04 pm
by Dildas
SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'

Re: Why have emojis?

Posted: Jan 15, 2019, 21:05 pm
by admin
:rofl:

Re: Why have emojis?

Posted: Jan 15, 2019, 21:05 pm
by Dildas
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

Re: Why have emojis?

Posted: Jan 15, 2019, 21:15 pm
by admin
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.

Re: Why have emojis?

Posted: Jan 16, 2019, 02:42 am
by JupiterStarWarrior
We can try *flipping* the table...?