List User Defined Tables , Procedures,Functions in database in alphabetical order

Posted by Teena under Sql Server category on | Points: 40 | Views : 2701
List User Defined Table

select table_name from INFORMATION_SCHEMA.Tables where TABLE_TYPE ='BASE TABLE' and substring(table_name,0,4) !='sys' order by table_name.

List User Defined Procedure

Select name from sys.procedures where [type] = 'P' and is_ms_shipped = 0 and [name] not like 'sp[_]%diagram%' order by name

List User Defined Functions

SELECT name FROM sys.objects WHERE type_desc LIKE '%FUNCTION%' order by name 

Comments or Responses

Login to post response