what is the query for seeing only stored procedures in sqlserver
Printable View
what is the query for seeing only stored procedures in sqlserver
CREATE OR REPLACE PROCEDURE [SCHEME.] procedurename
(argument {IN, OUT, IN OUT} data type,....) {IS, AS}
variable declarations:
constant declarations;
BEGIN
PL/SQL subprogram body;
EXCEPTION
exception PL/SQL block;
END;
Hi Gopi,
Its' simple just run the following query
Select * from sysobjects where xtype='P'
---V V---
Vikas Vaidya
[I]Please mark this post as thank if u found it useful[/I]
select * from sysobjects where type='p'