Was wondering if anyone has come across this issue or could help solve it.
Currently we have a table which holds contact information
ContactID, FirstTransactionDate, FirstTransactionValue
We are looking into a method of holding the table’s metadata in a separate table
So the process we need to do is check the Metadata Table and if there is a column name which exists in there, but not in the Data Table, then it needs to be created.
So in theory if the Metadata Table was populated with the following:
Then the process would identify that the last two columns don’t exist in the Data Table and create them accordingly.
So the data table structure would be:
ContactID, FirstTransactionDate, FirstTransactionValue, LastTransactionDate, LastTransactionValue
Has anyone come across this issue before and know a method of doing this?
Thanks in advance!