Visual Basic® .NET Database Programming

CREATE TABLE

After you create a database, you need to add tables to it. Tables hold a lot of information about the database structure. They hold the table’s field definitions, index definitions, and relational information.

Because tables hold so much information, the CREATE TABLE statement is quite complicated. The basic syntax looks like this:

CREATE TABLE table_name ( 
    field_name data_type [(size)] [DEFAULT default] [NOT NULL] 
[column_constraint], 
    field_name data_type [(size)] [DEFAULT default] [NOT NULL] 
[column_constraint], 
    ... 
    field_name data_type [(size)] [DEFAULT default] [NOT NULL] [column_constraint] 
[, CONSTRAINT table_constraint, ...] 
) 

The meanings of the parameters are

• field_name— Gives the name of the table’s field.

• data_type ...