테이블 및 뷰 확인 방법

select top(100)* from sys.views

-- 테이블 확인
select   table_schema, table_name   from information_schema.TABLE_CONSTRAINTS group by table_schema, table_name
-- 뷰 확인
select    table_schema,  view_name  from information_schema.VIEW_TABLE_USAGE group by table_schema, view_name
Previous
Next Post »