1556 shaares
120 private links
120 private links
1 result
tagged
delete
select
'' + char(13) + char(10)
- 'go' + char(13) + char(10)
- 'if ((select count(*) from ' + sys.schemas.name + '.[' + sys.tables.name +'])>0) '+ char(13) + char(10)
- 'begin' + char(13) + char(10)
- ' print ''---------------------'' ' + char(13) + char(10)
- ' print ''' + sys.schemas.name + '.' + sys.tables.name + ''' ' + char(13) + char(10)
- ' delete from ' + sys.schemas.name + '.[' + sys.tables.name +']'+ char(13) + char(10)
- 'end' + char(13) + char(10)
FROM sys.tables INNER JOIN sys.schemas ON sys.tables.schema_id = sys.schemas.schema_id
ORDER BY sys.schemas.name, sys.tables.name