SQL Server-how to use ADO to create databases and tables in SQL Server

You can access SQL Server through ado, and execute corresponding SQL statements to create databases and tables. The following are definitions in SQL Server books online.

Table creation:

Create Table
[
Database_name. [owner].
| Owner.
] Table_name
(
{
| Column_name as computed_column_expression

} [,... N]
)
[On {filegroup | default}]
[Textimage_on {filegroup | default}]

::={ Column_name data_type}
[[Default constant_expression]
| [Identity [(seed, increment) [not for replication]
]
[Rowguidcol]
[] [... N]

: = [Constraint constraint_name]
{
[Null | not null]
| [{Primary key | unique}
[Clustered | nonclustered]
[With fillfactor = fillfactor]
[On {filegroup | default }}
]
| [[Foreign key]
References ref_table [(ref_column)]
[Not for replication]
]
| Check [not for replication]
(Logical_expression)
}

: = [Constraint constraint_name]
{
[{Primary key | unique}
[Clustered | nonclustered]
{(Column [,... n])}
[With fillfactor = fillfactor]
[On {filegroup | default}]
]
| Foreign key
[(Column [,... n])]
References ref_table [(ref_column [,... n])]
[Not for replication]
| Check [not for replication]
(Search_conditions)
}

Database creation:

Create Database database_name
[On [primary]
[[,... N]
[, [,... N]
]
[Log on {[,... n]}]
[For Load | for attach]

: =

([Name = logical_file_name,]
Filename = 'OS _ file_name'
[, Size = size]
[, Maxsize = {max_size | unlimited}]
[, Filegrowth = growth_increment]) [,... n]

: =

Filegroup filegroup_name [,... n]