일(job)/DBMS
[MS-SQL] 데이터베이스의 특정컬럼 조회하기
뽀&쏭
2016. 1. 12. 15:22
SELECT obj.name, col.name
FROM sysobjects obj, syscolumns col
WHERE obj.id = col.id
AND obj.xtype = 'u'
AND obj.status > 0
AND col.name LIKE '%Fee_id%'
ORDER BY 1