I want to create tables in VB, as in the tables will not be connected to any kind of database. Instead, I want to be able to develop a table-like structure in VB. Any advice on the best approach for this?
You can do this with the Dataset object (presuming we're talking about a VB.NET application, not a VB6 application). It can contain DataTables which are made up of DataColumns. You can even specify relations between the DataTables. These can be built in memory (ie. on the fly) and do not have to be associated with "real" database objects at all.
Dig Deeper on .NET Development for SQL Server
Related Q&A from Greg Low
Learn why using the sp_OACreate stored procedure with a SQL Server 2005 trigger, is likely to result in a permissions problem.
Find how to query in SQL Server to get all database names created by users.
Find how to save stored procedure output to the network drive via SQL Server Management Studio.