[DATABASE/SQLSERVER] 테이블 존재 여부 조사하기

icodebroker SQLSERVER 2024-06-18

■ 테이블 존재 여부를 조사하는 방법을 보여준다.

▶ 테이블 (SQL)


SELECT COUNT(*) AS TableCount
FROM   SYSOBJECTS AS A
WHERE  A.xtype = 'U'
AND    A.name  = '테이블명';

1

2

3

4

5

6

SELECT COUNT(*) AS TableCount

FROM SYSOBJECTS AS A

WHERE A.xtype = 'U'

AND A.name = '테이블명';

▶ 임시 테이블 (SQL)


SELECT COUNT(*) AS TemporaryTableCount
FROM   tempdb.dbo.SYSOBJECTS AS A
WHERE  A.name LIKE '%테이블명%';

1

2

3

4

5

SELECT COUNT(*) AS TemporaryTableCount

FROM tempdb.dbo.SYSOBJECTS AS A

WHERE A.name LIKE '%테이블명%';