I would write a view and then you can do select * or move 800 columns names into rows in another table and create another table with an id,field and data colum

I would write a view and then you can do select * or move 800 columns names into rows in another table and create another table with an id,field and data column or separate...