Search results
15 sie 2019 · How can I drop all tables whose names begin with a given string? I think this can be done with some dynamic SQL and the INFORMATION_SCHEMA tables.
29 wrz 2016 · You can build up a string using the catalog views, e.g.: DECLARE @sql NVARCHAR(MAX) = N''; SELECT @sql += '. DROP TABLE '. + QUOTENAME(s.name) + '.' + QUOTENAME(t.name) + ';'. FROM sys.tables AS t. INNER JOIN sys.schemas AS s. ON t.[schema_id] = s.[schema_id]
11 paź 2011 · Here is a query to drop all tables that start with wp_pol in the current database: SELECT CONCAT('DROP TABLE ',GROUP_CONCAT(CONCAT(table_schema,'.',table_name)),';') FROM information_schema.tables WHERE table_schema=database() AND table_name like 'wp_pol%'; Next thing to do is store the result of it in
SQL Server allows you to remove multiple tables at once using a single DROP TABLE statement as follows: DROP TABLE [database_name.][schema_name.]table_name_1, Code language: SQL (Structured Query Language) (sql) [schema_name.]table_name_2, … [schema_name.]table_name_n; SQL Server DROP TABLE examples
16 lip 2019 · We use the SQL DROP Table command to drop a table from the database. It completely removes the table structure and associated indexes, statistics, permissions, triggers and constraints. You might have SQL Views and Stored procedures referencing to the SQL table.
The DROP TABLE statement allows you to remove multiple tables at the same time. To do this, you need to specify a list of comma-separated tables after the DROP TABLE clause as follows: DROP TABLE table_name1,table_name2,...;
18 paź 2023 · To drop a table from within the current database (on-premises or Azure SQL Database) we simply pass the name of the table in the form [schema_name].[table_name]. USE [MyDatabase] GO DROP TABLE [dbo].[MyTable3]; GO
