April 2002
Intermediate to advanced
416 pages
11h 50m
English
Databases such as SQL Server, MSDE, and Oracle use database servers to control access to any number of databases as shown in Figure A.2. A Visual Basic application connects to the server and can use SQL to make the server create databases, add and update records, and so forth.
The CREATE DATABASE command makes the server create a new database. The basic syntax of the CREATE DATABASE command is
CREATE DATABASE database_name
The database_name parameter names the new database.
Different database engines allow you to use additional arguments to specify the location of the database’s storage and log files. SQL Server and MSDE databases give you much more detailed control over how the database grows. With these databases, you can ...
Read now
Unlock full access