I need metadata of loaded tables, like number of rows, no of columns, type of data either numeric or character, number of nulls in table. Please help me if we can write some function or some way to get this information out of table.
When you load the QVDs using table file select the option xml. There you can see the meta data about your QVD file loaded. You can load this meta data into the separate QVD by store command