摘要: 库是否存在if exists(select * from master..sysdatabases where name=N'库名')print 'exists'elseprint 'not exists'----------------- 判断要创建的表名是否存在if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)-- 删除表dr 阅读全文
posted @ 2013-01-24 11:05 li-peng 阅读(18010) 评论(2) 推荐(7) 编辑