復(fù)制代碼 代碼如下:

　　USE [your_database_name_here];
　　GO
　　SELECT * FROM sys.all_objects
　　WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')
　　ORDER BY [name];
　　GO

復(fù)制代碼 代碼如下:

　　USE [your_database_name_here];
　　GO
　　SELECT * FROM sys.all_objects
　　WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')
　　AND [is_ms_shipped] = 0
　　ORDER BY [name];
　　GO