select o.name, user_name(o.uid), o.crdate, xtype=convert(nchar(2), o.xtype), o.id, OBJECTPROPERTY(o.id, N'ExecIsStartup'), OBJECTPROPERTY(o.id, N'ExecIsQuotedIdentOn'), OBJECTPROPERTY(o.id, N'ExecIsAnsiNullsOn'), OBJECTPROPERTY(o.id, N'IsMSShipped') from dbo.sysobjects o where (OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1) and o.name not like N'#%%' order by o.name
use mysql; show procedure status where type="procedure";
show procedure status where type="procedure";