I understand that you want a more elegant way to fetch variable types and names from the database. The implementation you have provided using “databaseImportOptions” to fetch variable names and types from the database and create an empty table is already a good approach this is another way you can do the same:
sqlquery = "SELECT * FROM table_name";
[results,metadata] = fetch(conn,sqlquery);
variableNames = metadata.Properties.RowNames;
variableTypes = metadata.VariableType;
data = table('Size', [0, numel(variableNames)], ...
'VariableTypes', variableTypes, ...
'VariableNames', variableNames);
You can also refer to the MATLAB documentation for "fetch" to obtain more information on its usage and syntax. The link is provided below: -
I hope this works!
