//删除所有视图
declare @sql varchar(8000)
set @sql=''
select @sql=@sql+ ', '+name from sysobjects
where type= 'V ' and name not in( 'syssegments ', 'sysconstraints ')
set @sql= 'drop view '+stuff(@sql, 1, 1, ' ')
exec(@sql)
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[branch_move_in_item]') AND type in (N'U'))
DROP TABLE [dbo].[branch_move_in_item]