[DATABASE/SQLSERVER] Identity 속성을 갖는 테이블/컬럼 찾기

icodebroker SQLSERVER 2024-06-18

■ Identity 속성을 갖는 테이블/컬럼을 찾는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    B.name AS [Table]
   ,A.name AS [Colum]
FROM  syscolumns A
JOIN  sysobjects B ON B.id = A.id
WHERE A.status = 128 -- Identity 컬럼은 0x80 값을 갖는다.
AND   B.name NOT LIKE 'queue_messages_%'
ORDER BY
    B.name ASC
   ,A.name ASC;

1

2

3

4

5

6

7

8

9

10

11

12

SELECT

B.name AS [Table]

,A.name AS [Colum]

FROM syscolumns A

JOIN sysobjects B ON B.id = A.id

WHERE A.status = 128 -- Identity 컬럼은 0x80 값을 갖는다.

AND B.name NOT LIKE 'queue_messages_%'

ORDER BY

B.name ASC

,A.name ASC;