repo_sys.usp_DropExtendedProperty_in_dwh - P

type: P ( stored procedure ), modify_date: 2021-09-30 15:46:29

RepoObject_guid: 863EFD10-0222-EC11-8524-A81E8446D5B0

Description

Examples

Parameters

  • @name (sysname)

  • @level0type (varchar(128))

  • @level0name (sysname)

  • @level1type (varchar(128))

  • @level1name (sysname)

  • @level2type (varchar(128))

  • @level2name (sysname)

Entity Diagram

entity-repo_sys.usp_dropextendedproperty_in_dwh

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo_sys.usp_dropextendedproperty_in_dwh

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo_sys.usp_dropextendedproperty_in_dwh

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo_sys.usp_dropextendedproperty_in_dwh

sql_modules_definition

repo_sys.usp_DropExtendedProperty_in_dwh - P script
Create Procedure repo_sys.usp_DropExtendedProperty_in_dwh
    @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'

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