Answers for "sql delete all tables starts with"

0

sql delete all tables starts with

SELECT 'IF OBJECT_ID(''' +TABLE_NAME + ''') IS NOT NULL BEGIN DROP TABLE [' + TABLE_NAME + '] END;' 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME LIKE '[prefix]%'
Posted by: Guest on May-01-2022

Code answers related to "sql delete all tables starts with"

Code answers related to "TypeScript"

Browse Popular Code Answers by Language