repo_sys.usp_DropExtendedProperty_in_self - P
type: P ( stored procedure ), modify_date: 2021-09-30 15:47:55
RepoObject_guid: 873EFD10-0222-EC11-8524-A81E8446D5B0
Parameters
-
@name (sysname)
-
@level0type (varchar(128))
-
@level0name (sysname)
-
@level1type (varchar(128))
-
@level1name (sysname)
-
@level2type (varchar(128))
-
@level2name (sysname)
sql_modules_definition
repo_sys.usp_DropExtendedProperty_in_self - P script
Create Procedure repo_sys.usp_DropExtendedProperty_in_self
@name sysname
, @level0type Varchar(128) = Null
, @level0name sysname = Null
, @level1type Varchar(128) = Null
, @level1name sysname = Null
, @level2type Varchar(128) = Null
, @level2name sysname = Null
As
--Declare @DbName sysname = config.fs_dwh_database_name ();
--Declare @module_name_var_drop NVarchar(500) = QuoteName ( @DbName ) + N'.sys.sp_dropextendedproperty'
Declare @module_name_var_drop NVarchar(500) = N'sys.sp_dropextendedproperty'
Begin Try
--EXEC [sys].sp_dropextendedproperty
Exec @module_name_var_drop
@name = @name
, @level0type = @level0type
, @level0name = @level0name
, @level1type = @level1type
, @level1name = @level1name
, @level2type = @level2type
, @level2name = @level2name
End Try
Begin Catch
Print 'Can''t drop extended property:'
Print Concat (
@name
, ';'
, @level0type
, ';'
, @level0name
, ';'
, @level1type
, ';'
, @level1name
, ';'
, @level2type
, ';'
, @level2name
, ';'
)
End Catch