1.首先我们需要判断是哪个用户锁住了哪张表. --查询被锁表select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' 查询后会返回一个包含
1、判断数据表是否存在 方法一: use yourdb;goif object_id(N'tablename',N'U') is not nullprint '存在'else print '不存在' 例如: use fireweb;goif object_id(N'TEMP_TBL',N'U') is not nullprint '存在'else print '不存在'
1.查询当前数据库所有表 复制代码 代码如下: SELECT O.object_id AS TableId, TableName=O.name , TableDesc= O.type FROM sys.columns C INNER JOIN sys.objects O ON C.[object_id]=O.[object_id] AND O.type='U' AND O.is_ms_shippe
复制代码 代码如下: DECLARE cur CURSOR FOR SELECT [object_name]=s.name+'.'+OBJECT_NAME(A.object_id), B.name FROM sys.dm_db_index_physical_stats(DB_ID('AdventureWorks'),NULL,null,null,null) AS A JOIN sys.indexe