Shulou(Shulou.com)06/01 Report--

-- take the temporary table # temp as an example to determine whether it exists or not. Delete it if it exists. Delete it IF OBJECT_ID ('tempdb..#temp') is not nulldrop table # temp-- method-1if exists (select * from tempdb.dbo.sysobjects where id = object_id (Numbertempdb.. tempcitys') and type='U') 2 drop table # tempcitys-- method Diif object_id (' tempdb..#tem') is not null begin print 'exists' end else begin print' not exists' end

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.