Hi,

I need to find out the function(s) which generate the value of VIRTUAL/PERSISTENT column. According to documentation here- https://mariadb.com/kb/en/mariadb/documentation/sql-commands/data-definition... I have to use *SHOW CREATE TABLE.. *to get the definition. It is doable of course but It involves painful parsing of returned create table statement to get the required function(s)( As I want to display them in GUI client.)

This function(s) is not returned in *show full fields from... *and I can't find any relevant information in INFORMATION_SCHEMA also.

So my question is- Is there any better way of getting this information other than using SHOW CREATE TABLE.. and do parsing? or is it the only way of accomplishing it?

Regards, Abhishek.