Search results
22 gru 2014 · Generate Drop scripts in the select statement and drop it using Dynamic SQL: DECLARE @sql NVARCHAR(max)=''. SELECT @sql += ' Drop table ' + QUOTENAME(TABLE_SCHEMA) + '.'+ QUOTENAME(TABLE_NAME) + '; '. FROM INFORMATION_SCHEMA.TABLES. WHERE TABLE_TYPE = 'BASE TABLE'.
A modern SQL dialect used by BigQuery, Databricks, or Snowflake proposes an excellent solution. SELECT * EXCEPT (ColumnNameX, [ColumnNameY, ...]) FROM TableA. This very powerful SQL syntax avoids a long list of columns that must be constantly updated due to table column name changes.
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]
8 lip 2024 · In SQL Server, we can write a T-SQL (Transact-SQL) script to drop all the tables inside a schema: DECLARE @sql NVARCHAR(MAX) = ''; SELECT @sql += 'DROP TABLE ' + QUOTENAME(table_schema) + '.' + QUOTENAME(table_name) + ';' + CHAR (13) FROM information_schema.tables.
if your database column contains below table names: column_name ----- test_kin1 test_kin2 test_kin3 Then you can use: select 'drop table '+quotename(column_name) + char(10) +'go'from table_name In text mode it will generate sql to drop them.
2 kwi 2021 · Solution. We’ll look at three ways to drop all tables in a database. Drop Tables from SQL Server Management Studio (SSMS) Dynamically Generate SQL to Drop Constraints and Tables Programmatically. Dynamically Generate and Execute SQL to Drop Constraints and Tables Programmatically.
19 paź 2022 · SQL DROP Table for all Tables in a SQL Server Database. The solution is straightforward - list all tables in your SQL Server database, for example, in one DROP statement separated by commas. Example syntax: DROP TABLE table1, table2, table3, table4, table5;
