Search code examples
mysql-connectorsinglestore

Is there an easier way to discover function parameters in MemSQL?


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 });

Solution

  • 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.