USP_QUERYVIEWCATALOG_GETATTRIBUTEEXTENSIONQUERYVIEWS
Definition
Copy
CREATE procedure dbo.USP_QUERYVIEWCATALOG_GETATTRIBUTEEXTENSIONQUERYVIEWS
as
begin
select
QUERYVIEWCATALOG.QUERYVIEWSPEC,
QUERYVIEWEXTENSIONCATALOG.ID ATTRIBUTEEXTENSIONID
from dbo.QUERYVIEWCATALOG
left join dbo.QUERYVIEWEXTENSIONCATALOG
on QUERYVIEWCATALOG.ID = QUERYVIEWEXTENSIONCATALOG.QUERYVIEWCATALOGID
and QUERYVIEWEXTENSIONCATALOG.ISATTRIBUTEEXTENSION = 1
where QUERYVIEWCATALOG.ALLOWATTRIBUTEEXTENSION = 1
end