Setting in DBeaver

Help Procedural SQL
1

while executing the
show create procedure <proceudre_name>
it will execute create procedure column with paramater

CREATE OR REPLACE PROCEDURE report(p_lob text CHARACTER SET utf8 COLLATE utf8_general_ci NULL)
.
.
End;

is there any option not to show CHARACTER SET utf8 COLLATE utf8_general_ci NULL
?

2

Sorry, no, we don’t have that option. Why do you ask?

If you want total control, you can query information_schema.routines and information_schema.parameters and write your own pretty-printer that strips that out.

3

Thanks because every time I am trying to format I need to review this code…