You can also use Bytebase to change stored procedures by supplying the raw SQL. Same apply for triggers.

  1. Go to a project, select a target database, then Edit Schema.

  2. In the popup, switch to Raw SQL and supply the SQL statement. The example below adds a stored procedure to reverse the string.

  3. Create the rollout issue.

  4. Review and rollout the issue.

  5. Check the change history that records the change statement and the schema diff.