Could anybody please clarify me what is metadata used for?
In my project, we have an existing metadata which is maintained in excel sheets and contain several fields like TableName, ColumnName, DisplayName, IsRequired, FilterValue,DependentTableName etc.
The front-end is ASP and backend is SQL Server. I understood that the metadata is describing the data and relations between the data. But I dont understand why do we need to maintain this metadata? what is the main purpose of this? And in the same excel file, we also have another sheet named "Script" which contains "Create Script" and "Execute Script" .
I appreciate your clarifications!