Link to home
Create AccountLog in
Avatar of Easwaran Paramasivam
Easwaran ParamasivamFlag for India

asked on

How to take backup of SP/UDF before altering it?

Before dropping a table we check if exist delete it. We can use INTO statement to take backup of the table.

Likewise is there any way to take the backup of SP/Function to either in the DB or in File in specified path before modifying it?

Please do suggest. Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Easwaran Paramasivam

ASKER

I've read your other aticles as well. Awesome. Keep doing!! Thanks.