maria-discuss team mailing list archive

[Abhishek Kumar Pandey <abhishek.pandey@xxxxxxxxxx>]

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/create/virtual-columns/
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.