Should sql schema within retool display stored procedures?

Queries and Resources
1

Does the mysql schema within retool display stored procedures, or just tables?

1 Like
2

Hey @brian.hickey! Welcome to the community. :slightly_smiling_face:

I'm pretty sure Retool only gives a preview of tables in the public schema. It's fairly straightforward to write a query that lists all defined routines, though:

SELECT  routine_schema,  
        routine_name,  
        routine_type 
FROM information_schema.routines 
WHERE routine_schema = 'your_database_name' 
ORDER BY routine_name;
1 Like