테이블목록, 컬럼상세내역보기

테이블 목록보기
sp_tables
select * from information_schema.tables

 

컬럼 상세내용보기
sp_columns 테이블명
select * from information_schema.columns where table_name = '테이블명'
select column_name, data_type, character_maximum_length, column_default from information_schema.columns where table_name = '테이블명'