Back
  1. Home
  2. How to alter store procedure?

How to alter store procedure?

Vivek Nayak's picture
Vivek Nayak 22 August 2019
SQL, InterSystems IRIS

I have created store procedure using management portal.

how to alter or modify SP using SQL in management portal.

Please refer below screen.

  • + 1
  • 0
  • 71
  • 2
  • 1
Vivek Nayak's picture
Vivek Nayak 22 August 2019

Answers

Eduard Lebedyuk's picture
Answer by Eduard Lebedyuk 22 August 2019

You can alter queries via Studio/Atelier/VS Code IDEs.

In portal you can run DROP QUERY and create the query again.

0   0
Accepted answer
Vivek Nayak's picture
Comment by Vivek Nayak 23 August 2019

Is it possible to alter SP using portal?

Something like below,

Alter query queryname()

0 0