Why Use SQL to Create and Manage Data Tables?
Before you jump into the details of SQL keywords, let’s talk about the advantages of using SQL statements to create and manage your data tables. Although Visual Basic offers several powerful commands for performing the same functions within a Visual Basic program, you might find that using SQL keywords to perform database management gives you an advantage. By using SQL statements to create and maintain your database structures, you can easily create useful documentation on how your databases are structured. Are you trying to debug a problem at a client site and can’t remember how the tables are laid out? If you used a set of SQL statements to create the tables, you can refer to that script when you are solving your client’s problems. It is also easy to generate, test, or sample data tables using SQL statements. If you are working on a database design and are still experimenting with table layouts and relationships, you can quickly put together an SQL DDL script, run it through SQL-VB5,
