Pages

Search This Blog

Showing posts with label generate. Show all posts
Showing posts with label generate. Show all posts

Thursday, September 23, 2010

[T-SQL] Generate Delete script for all tables

You can use this script for generate delete script or even trncate

select 'delete from ' + o.name + ';'
from sysobjects o
where o.type = 'U';