dynamic_field_info - Linux


dynamic_field_info is a Linux command that provides information about dynamic fields in SAP HANA. Dynamic fields are additional fields that can be added to tables without modifying the table definition. They are often used to store additional data that is not part of the core table structure.


dynamic_field_info [OPTIONS] [TABLE]


  • -h, –help: Display help information.
  • -v, –verbose: Enable verbose output.
  • -s, –short: Display only a summary of the information.
  • -f, –fields: Specify a comma-separated list of fields to display information about.
  • -t, –table: Specify the name of the table to display information about.


Display information about all dynamic fields in a table

dynamic_field_info my_table

Display information about a specific dynamic field

dynamic_field_info my_table -f my_field

Display a summary of the information

dynamic_field_info my_table -s

Common Issues

If dynamic_field_info does not return any results, it is possible that the table does not have any dynamic fields.


dynamic_field_info can be used with other Linux commands to automate tasks. For example, the following command can be used to create a CSV file containing the information about all dynamic fields in a table:

dynamic_field_info my_table | sed 's/ /,/g' > my_fields.csv

Related Commands

  • hana_table_info: Display information about SAP HANA tables.
  • hana_view_info: Display information about SAP HANA views.