개의 블로그 개의 블로그

Programming/SQL

• mssql 컬럼 검색, 문자열 찾기

  Programming/SQL 2021. 1. 5. 17:26

  -- 컬럼 검색 SELECT DISTINCT T.NAME AS TABLE_NAME FROM SYS.TABLES AS T INNER JOIN SYS.COLUMNS AS C ON T.OBJECT_ID = C.OBJECT_ID WHERE C.NAME LIKE '%부서%' --문자열 찾기 SELECT DISTINCT OBJECT_NAME(ID) FROM SYS.SYSCOMMENTS WHERE TEXT LIKE '%내가찾을문자열%'

  Read More