MS Sql - System Table (Schema 정보)

[ MS Sql - System Table (Schema 정보)  ]

 

 

INFORMATION_SCHEMA. 을 기준으로 MS Sql Schema 정보를 볼 수 있다.

 

--컬럼정보

select * from information_schema.columns where table_name = 'table_name';

 

--테이블정보
select * --column_name, data_type, character_maximum_length, column_default from INFORMATION_SCHEMA.TABLES where table_name = 'table_name';

 

--View정보
select * --column_name, data_type, character_maximum_length, column_default from INFORMATION_SCHEMA.VIEWS;

 

--Procedure

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%execute%' AND ROUTINE_TYPE='PROCEDURE' order by ROUTINE_NAME;