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

Teena
Posted by Teena under Sql Server category on | Points: 40 | Views : 2775
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