stored procedure

Database
sjm
Enthusiast

stored procedure

I am new to Teradata , have experience in oracle 

 

how do i view the body of the stored procedure (code)

 

 

2 REPLIES
Teradata Employee

Re: stored procedure

If it is a SQL Stored Procedure and the creator opted to have the database keep a copy of the source code, then use the SHOW PROCEDURE statement.

 

Best practice is to keep the code for stored procedures, user-defined functions, etc. in some source control system.

sjm
Enthusiast

Re: stored procedure

Thanks for your reply