MS sqlserver one-time deletion of all tables and views, etc.

Declare @ tablename varchar (50) Declare @ Type varchar (50) Declare @ truncatesql varchar (255) Declare trcun_cursor cursor forselect [name], [type] From sysobjects where type = 'U' or type = 'V' -- conditional table name clearing <> 'table name not clearing '-- open trcun_cursorfetch trcun_cursor into @ tablename, @ typewhile (@ fetch_status = 0) begin if @ type = 'V' set @ truncatesql = 'drop view' + @ tablename exec (@ truncatesql) -- to delete a file, remove -- print @ truncatesql if @ type = 'U' set @ truncatesql = 'drop table' + @ tablename exec (@ truncatesql) -- to delete a table, remove -- print @ truncatesql fetch trcun_cursor into @ tablename, @ typeendclose trcun_cursordeallocate trcun_cursor