(TSQL)組合出TRUNCATE TABLE等指令

	SELECT 'TRUNCATE TABLE '+TABLE_SCHEMA + '.' + TABLE_NAME as '結果'
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'BASE TABLE'
	AND TABLE_SCHEMA = 'dbo' --Schema Name
	AND TABLE_NAME like 'XYX%'
	ORDER BY 結果
	-------
	SELECT 'TRUNCATE TABLE '+TABLE_SCHEMA + '.' + TABLE_NAME as '結果'
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'BASE TABLE'
	AND TABLE_SCHEMA = 'dbo'
	-------
	SELECT 'DROP VIEW '+TABLE_SCHEMA + '.' + TABLE_NAME as '結果'
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_TYPE = 'VIEW'
	AND TABLE_SCHEMA = 'dbo'

view raw <TSQL>組合出TRUNCATE TABLE等指令 hosted with ❤ by GitHub