The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

statement metadata

Hi,

Is there an equivalent function or stored procedure to Sql Server sys.dm_exec_describe_first_result_set?

The goal is not to get the table or view metadata but the returned dataset metadata of a statement indead.

thanks

Answer Answered by Vladislav Vaintroub in this comment.

No, there is no equivalent function that would return metadata, with SQL function.

This functionality is implemented on the protocol level though (https://dev.mysql.com/doc/internals/en/com-stmt-prepare-response.html)

Thus, some APIs might return this information. Here is how it works in JDBC https://docs.oracle.com/javase/7/docs/api/java/sql/PreparedStatement.html#getMetaData()

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.