Lists all the user defined stored procedures. 1

[VDhir]

Hi All

Function - : Lists all the user defined stored procedures.

SELECT Name FROM SYSOBJECTS
WHERE (TYPE = 'P') AND (OBJECTPROPERTY(OBJECT_ID(Name), 'IsMSShipped') = 0)
ORDER BY Name

Function - : Lists all the user defined Tables.

SELECT Name FROM SYSOBJECTS
WHERE (TYPE = 'U') AND (OBJECTPROPERTY(OBJECT_ID(Name), 'IsMSShipped') = 0)
ORDER BY Name


and you can check other results by changing the Type parameter in the query

Possible Types are -:

S, D, U, F, P, V, K


Regards
Dhir

 

[Cagliostro]

Is it a question? I think is a helpful tip. John Fill

ivfmd@mail.md