I need to enumerate all parameters in a MemSQL function. Is there an easier way other than using SHOW CREATE FUNCTION
and then parsing the definition? For example, when using MySql, I could use
connection.GetSchema("Procedure Parameters",
new string[] { null, database, structureName });
Unfortunately there isn't really a better approach right now. The GetSchema
method from your example makes use of a MySQL metadata table that is currently unsupported in MemSQL.