By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
object_id | definition | uses_ansi_nulls | uses_quoted_identifier | is_schema_bound | uses_database_collation | is_recompiled | null_on_null_input | execute_as_principal_id | uses_native_compilation |
---|---|---|---|---|---|---|---|---|---|
885578193 | CREATE PROCEDURE my_proc AS SELECT 1; |
True | True | False | False | False | False | null | False |
ROUTINE_DEFINITION | SPECIFIC_CATALOG | SPECIFIC_SCHEMA | SPECIFIC_NAME | ROUTINE_CATALOG | ROUTINE_SCHEMA | ROUTINE_NAME | ROUTINE_TYPE | MODULE_CATALOG | MODULE_SCHEMA | MODULE_NAME | UDT_CATALOG | UDT_SCHEMA | UDT_NAME | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | COLLATION_CATALOG | COLLATION_SCHEMA | COLLATION_NAME | CHARACTER_SET_CATALOG | CHARACTER_SET_SCHEMA | CHARACTER_SET_NAME | NUMERIC_PRECISION | NUMERIC_PRECISION_RADIX | NUMERIC_SCALE | DATETIME_PRECISION | INTERVAL_TYPE | INTERVAL_PRECISION | TYPE_UDT_CATALOG | TYPE_UDT_SCHEMA | TYPE_UDT_NAME | SCOPE_CATALOG | SCOPE_SCHEMA | SCOPE_NAME | MAXIMUM_CARDINALITY | DTD_IDENTIFIER | ROUTINE_BODY | ROUTINE_DEFINITION | EXTERNAL_NAME | EXTERNAL_LANGUAGE | PARAMETER_STYLE | IS_DETERMINISTIC | SQL_DATA_ACCESS | IS_NULL_CALL | SQL_PATH | SCHEMA_LEVEL_ROUTINE | MAX_DYNAMIC_RESULT_SETS | IS_USER_DEFINED_CAST | IS_IMPLICITLY_INVOCABLE | CREATED | LAST_ALTERED |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CREATE PROCEDURE my_proc AS SELECT 1; |
fiddle_642c6a1d376b4a4794134b54849150cf | dbo | my_proc | fiddle_642c6a1d376b4a4794134b54849150cf | dbo | my_proc | PROCEDURE | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | null | SQL | CREATE PROCEDURE my_proc AS SELECT 1; |
null | null | null | NO | MODIFIES | null | null | YES | -1 | NO | NO | 28/06/2019 15:35:50 | 28/06/2019 15:35:50 |