[MSSQL] sys 함수 정리

MS Docs
https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-all-views-transact-sql?view=sql-server-ver16

 

 

 

1. View

 

SELECT OBJECT_NAME(OBJECT_ID) Name_
,OBJECT_DEFINITION(OBJECT_ID) Script_
FROM sys.views

WHERE 1=1

 

 

2. Procedure

SELECT OBJECT_NAME(OBJECT_ID) Name_
,OBJECT_DEFINITION(OBJECT_ID) Script_
FROM sys.procedures
WHERE 1=1

 

 

SP_HELPTEXT '   '

 

 

3. ALL

 

SELECT ROUTINE_NAME NAME_
,ROUTINE_DEFINITION Script_
,ROUTINE_TYPE TYPE_
FROM   INFORMATION_SCHEMA.ROUTINES        
WHERE  1=1