Member Avatar for rony001

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"
  • 2 Contributors
  • 2 Replies
  • 93 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by rony001
Member Avatar for urtrivedi

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

Member Avatar for rony001

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.