查询整个数据库 ,有没有以 'prod' 开头的字段:
exec sp_MSforeachtable'
SELECT * FROM sys.columns
WHERE OBJECT_ID=OBJECT_ID(''?'')
AND name LIKE ''%Prod%'''
查询整个数据库 ,有没有以 'prod' 开头的字段:
exec sp_MSforeachtable'
SELECT * FROM sys.columns
WHERE OBJECT_ID=OBJECT_ID(''?'')
AND name LIKE ''%Prod%'''