SQL Server Generate backup on new schema iterating over certain tables - T-SQL

hivapdat 于 2023-06-28 发布在其他

关注(0)|答案(1)|浏览(109)

I got a list of table names from sys.tables that looks like this:

SELECT name
FROM sys.tables
WHERE name LIKE 'ETL%'

I want to move to a new schema (kinda like a backup) and I was thinking of using something like the following query being @table_name the current item from the list:

SELECT *
INTO [historic].[@table_name]
FROM @table_name

However I cannot seem to sort out how I can make this kind of iterator.

sql-server

来源：https://stackoverflow.com/questions/76558398/generate-backup-on-new-schema-iterating-over-certain-tables-t-sql

1条答案

按热度按时间

vkc1a9a21#

You're probably only going to perform this once, you can use the following example query to construct the SQL statements needed, you can copy and paste into an SSMS window to use.

select Concat(
  'select * ',
  'into [historic].', QuoteName(name),
  ' from ', QuoteName(name), ';'
)
from sys.tables
where name like 'ETL%' and Schema_Name(schema_id) = 'dbo';

赞(0）回复(0）举报 2023-06-28

我来回答

SQL Server Generate backup on new schema iterating over certain tables - T-SQL

1条答案

相关问题

热门标签

最新问答