FireDAC TFDMetaDataQuery default field value

[Mark Williams 14]

Trying to analyse the structure of a table using TFDMetaDataQuery with MetaDataKind set to mkTableFields.

 

This returns just about everything I need apart from (as far I can see) a field's default value.

 

I can see it returns TFDDataAttributes and that this includes an attribute caDefault which advises if a field has a default value, but I can see now way of ascertaining what the default value is.

 

The metadata structure can be found at:

http://docwiki.embarcadero.com/RADStudio/Rio/en/Metadata_Structure_(FireDAC)

[Lars Fosdal 1792]

Which database?

 

For SQL Server, there is this: https://stackoverflow.com/questions/3817885/sql-server-find-out-default-value-of-a-column-with-a-query

[Mark Williams 14]

4 hours ago, Lars Fosdal said:

Which database?

 

For SQL Server, there is this: https://stackoverflow.com/questions/3817885/sql-server-find-out-default-value-of-a-column-with-a-query

Thanks Lars. There is a query for PostgreSQL which will retrieve this info, but I was hoping to do it all with the MetaDataQuery.