[DATABASE/SQLSERVER] 데이타베이스 테이블 조회하기

■ 데이타베이스 테이블을 조회하는 방법을 보여준다.

▶ 예제 코드 (SQL)


SELECT
    A.TABLE_CATALOG AS [Database]
   ,A.TABLE_SCHEMA  AS [Schema]
   ,A.TABLE_NAME    AS [Table]
FROM     INFORMATION_SCHEMA.TABLES AS A
WHERE    A.TABLE_TYPE = 'BASE TABLE'
ORDER BY A.TABLE_NAME;

SELECT

A.TABLE_CATALOG AS [Database]

,A.TABLE_SCHEMA AS [Schema]

,A.TABLE_NAME AS [Table]

FROM INFORMATION_SCHEMA.TABLES AS A

WHERE A.TABLE_TYPE = 'BASE TABLE'

ORDER BY A.TABLE_NAME;