text: IF OBJECT_ID('[DOI].[spRefreshMetadata_1_Columns]') IS NOT NULL
  	DROP PROCEDURE [DOI].[spRefreshMetadata_1_Columns];
  
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET ANSI_NULLS ON
  GO
  CREATE   PROCEDURE [DOI].[spRefreshMetadata_1_Columns]
      @DatabaseName NVARCHAR(128) = NULL
  
  AS
      EXEC DOI.spRefreshMetadata_0_Databases
          @DatabaseName = @DatabaseName
  
      EXEC [DOI].[spRefreshMetadata_System_SysColumns]
          @DatabaseName = @DatabaseName
  
      EXEC [DOI].[spRefreshMetadata_System_SysIdentityColumns]
          @DatabaseName = @DatabaseName
  
      EXEC [DOI].spRefreshMetadata_System_SysColumns_UpdateData
          @DatabaseName = @DatabaseName
  
  GO