if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms
GO

Create Procedure {databaseOwner}[{objectQualifier}DataSprings_DynamicViews_LoadDynamicForms]
@PortalID Int
AS

Select A.ModuleID, B.ModuleTitle + ' / ModuleID: ' + Cast(A.ModuleID as nvarchar(7)) As ModuleTitle from {databaseOwner}[{objectQualifier}Modules] A
Inner Join {databaseOwner}[{objectQualifier}TabModules] B on A.ModuleID = B.ModuleID
Where ModuleDefID In (Select ModuleDefID from {databaseOwner}[{objectQualifier}ModuleDefinitions] where FriendlyName like '%Dynamic Forms%') 
AND PortalID = @PortalID
AND A.IsDeleted =0
GO