MSSQL Objects query currently excludes CLR based objects

The objects query currently excludes objects based on the CLR like procedures and UDF's. The xtype's are as follows:

PC - CLR Stored Procedure
FT - CLR Table-Valued function
FS - CLR Scalar-Valued function

Can we get this added to the default query? Yes, I can add it to my own.

Current Objects query:

select
name, xtype, id
from
/*db.*/dbo.sysobjects
where
xtype in ('U','S','V','P','X','RF','FN','TF','IF')
and uid = :SCHEMA_ID
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype = 'P')

Suggested Objects Query:

select
name, xtype, id
from
/*db.*/dbo.sysobjects
where
xtype in ('U','S','V','P','X','RF','FN','TF','IF', 'PC', 'FT', 'FS')
and uid = :SCHEMA_ID
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype = 'P')

It seems as though you are translating xtypes to types for internal handling. Changing the query didn't cause those new items to show in the proper place.

"EXEC " didn't cause the xtype PC items to show.
"Select dbo." didn't cause the xtype FS to show
"Select * dbo." didn't cause the xtype FT to show.

Build: 3.0.24 Using: SSMS on SQL 2005.

Build: 3.0.24
Using: SSMS on SQL 2005.

Thanks. I will add it as an enhancement request

In the output, you need to map these types to type 'P' so that SQL Assistant can treat them as regular stored procedures. Right now, it simply doesn't know what to do with them and what kind of objects they are.

Here is the query if it is of use to anyone. BTW, SSMS crashed after changing to this query and clicking ok.

QUERY:
select
name, xtype = Case xtype
when 'PC' then 'P'
when 'FT' then 'TF'
when 'FS' then 'FN'
else xtype
end, id
from
/*db.*/dbo.sysobjects
where
xtype in ('U','S','V','P','X','RF','FN','TF','IF', 'PC', 'FT', 'FS')
and uid = :SCHEMA_ID
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype = 'P')

ERROR:
SqlWb.exe - Application Error : The instruction at "0x081b6078" referenced memory at "0x081b6078". The memory could not be "read".

Updated for 3.5.11 (support for synonyms)

select
name, xtype = Case xtype
when 'PC' then 'P'
when 'FT' then 'TF'
when 'FS' then 'FN'
else xtype
end, id
from
/*db.*/dbo.sysobjects
where
xtype in ('U','S','V','P','X','RF','FN','TF','IF', 'SN', 'PC', 'FT', 'FS')
and uid = :SCHEMA_ID
and not (name = 'dtproperties')
and not (name like 'dt%' and xtype = 'P')

Thank you. I just tried it and it works fine for me.

Similar change for supporting CLR based objects will appear in the next SQL Assistant build.