tag:blogger.com,1999:blog-495177919198719500.post3789927499008517064..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: Drop All Tables in Database whose name begins with tmpSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-495177919198719500.post-90484914948819996632017-01-27T10:46:53.532-08:002017-01-27T10:46:53.532-08:00Thanks very much!Thanks very much!Unknownhttps://www.blogger.com/profile/11160260865373133835noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-44537786295624505692015-10-29T09:53:50.534-07:002015-10-29T09:53:50.534-07:00Since it's PostgreSQL, the + sign will not con...Since it's PostgreSQL, the + sign will not concatenate strings. You should do like this<br /><br />select 'drop table ' || table_name || ';' from INFORMATION_SCHEMA.TABLES where table_name like 'tmp_%'<br /><br />Adding the ; needed in order to not get the syntax errorMelvin Ramoshttps://www.blogger.com/profile/03781139084135851109noreply@blogger.com