||To create a database table, use the SQL command |
CREATE TABLE. The command is pretty complex, and before you start creating tables via SQL code, be sure to read up on the command in the SQL Books On-Line. The basic structure of the
CREATE TABLE statement is as follows:
CREATE TABLE TableName
ColumnName1 Datatype Properties
ColumnName2 Datatype Properties
ColumnNameN Datatype Properties
So, to create a table named
FooBar with Name and Age columns, you could use the following SQL script:
CREATE TABLE FooBar
To view a short example on how to accomplish this through an ASP page, take a moment to read this ASPMessageboard post!
The above example works well for creating a database table... but what if you want to create, say, an entire Access database (including the
.MDB file itself)? Fortunately Microsoft has provided a set of libraries referred to as ADOX which allow for this functionality. To learn more about ADOX be sure to read: Working with ADOX.