I am not a programmer just learning. I would like to know how to save the scheme info into a table ? I have this sql statement that seems to work but how do i save the info into a table

 Dim CmdStr As String = " SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES"

its done on its own. when you create table when you add coulmn, information scheams is managaged by mysql server. You dont have to worry about it, you just use like the query you are using above

Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.