How to write code in C#, Asp.Net, Php, Javascript, C. On this blog you will find example codes that will help you to understand concepts of programming.
Thursday, June 7, 2012
How to get list with procedures, functions or views in Sql?
In order to obtain a list with procedures(P), functions(FN) or views(V) in Sql you can run this query:
SELECT [name], [type], create_date, modify_date
FROM sys.objects
WHERE [type] in ('P', 'FN', 'V')
order by [Type ] asc
No comments:
Post a Comment