MSSQL 각종 조회 쿼리

select
  A.PARAMETER_MODE as MODE,
  A.PARAMETER_NAME as [NAME],
  A.DATA_TYPE as [TYPE],
  A.CHARACTER_MAXIMUM_LENGTH as LENGTH
from INFORMATION_SCHEMA.PARAMETERS A
where A.SPECIFIC_NAME = '프로시저명 or 함수명'
ORDER BY A.ORDINAL_POSITION 
  
--테이블의 컬럼 정보
Select
  A.Column_Name as [NAME],
  A.Is_Nullable as [ISNULL],
  A.Data_Type as [TYPE],
  A.Character_Maximum_Length as [LENGTH],
  B.Column_Name as PK
from INFORMATION_SCHEMA.COLUMNS A
LEFT OUTER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE  B
 On A.Table_Name = B.Table_Name
 AND A.Column_Name = B.Column_Name
where A.Table_Name = '테이블명'

--전체 테이블 목록
Select
  [NAME],
  Max_Column_Id_Used as Cols
from sys.tables
order by name

--전체 함수 목록
Select [name] from sys.Objects
where [type] = 'FN'
order by name

--전체 뷰 목록
Select [name] from sys.views
order by name

--전체 프로시저 목록
Select [name] from sys.procedures
order by name