Wednesday, 6 December 2006

Truncate all tables 

/*
Dynamic SQL to achieve this
*/
SELECT 'TRUNCATE TABLE [' +table_schema + '].[' + TABLE_NAME +']'
FROM INFORMATION_SCHEMA.TABLES
By -

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)