Summary
Visual Basic’s DataTable and SqlDataReader objects, and the SqlDataReader’s GetSchemaTable method can give you information about a table or the fields selected by a database query. SQL Server stored procedures give you even more information about database objects. They can list a server’s databases, a database’s tables, and a table’s columns. They can tell you about the properties of a database, column, or table, and they can describe the relationships among a database’s tables.
When you build a database, you can keep track of its structure by recording the steps you take to build it. If you build it using SQL scripts, just be sure to keep copies of the scripts. For databases you did not create, Visual Basic’s database objects and the ...
Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
