select 'drop table '+name+';' from sys.tables
select 'alter table '+name+' nocheck constraint all' from sysobjects where type='U'