sys.system_sql_modules (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Returns one row per system object that contains a SQL language-defined module. System objects of type FN, IF, P, PC, TF, V have an associated SQL module. To identify the containing object, you can join this view to sys.system_objects.
| Column name | Data type | Description |
|---|---|---|
| object_id | int | Object identification number of the containing object, unique within a database. |
| definition | nvarchar(max) | SQL text that defines this module. |
| uses_ansi_nulls | bit | 1 = Module was created with the SET ANSI_NULLS database option ON. Always returns 1. |
| uses_quoted_identifier | bit | 1 = Module was created with SET QUOTED_IDENTIFIER ON. Always returns 1. |
| is_schema_bound | bit | 0 = Module was not created with the SCHEMABINDING option. Always returns 0. |
| uses_database_collation | bit | 0 = Module does not depend on the default collation of the database. Always returns 0. |
| is_recompiled | bit | 0 = Procedure was not created by using the WITH RECOMPILE option. Always returns 0. |
| null_on_null_input | bit | 0 = Module was not created to produce a NULL output on any NULL input. Always returns 0. |
| execute_as_principal_id | int | Always returns NULL |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
sys.sql_modules (Transact-SQL)
sys.all_sql_modules (Transact-SQL)
Catalog Views (Transact-SQL)
Object Catalog Views (Transact-SQL)