Through ADO, SQLSERVER can be accessed and the corresponding SQL statements can be executed to build libraries and tables. The following are the relevant definitions in SQLSERVERBOOKSONLINE.
Create table:
CREATETABLE
[
database_name.[owner].
|owner.
]table_name
(
{
|column_nameAScomputed_column_expression
}[,...n]
)
[ON{filegroup|DEFAULT}]
[TEXTIMAGE_ON{filegroup|DEFAULT}]
::={column_namedata_type}
[[DEFAULTconstant_expression]
|[IDENTITY[(seed,increment)[NOTFORREPLICATION]]]
]
[ROWGUIDCOL]
[][...n]
::=[CONSTRAINTconstraint_name]
{
[NULL|NOTNULL]
|[{PRIMARYKEY|UNIQUE}
[CLUSTERED|NONCLUSTERED]
[WITHFILLFACTOR=fillfactor]
[ON{filegroup|DEFAULT}}
]
|[[FOREIGNKEY]
REFERENCESref_table[(ref_column)]
[NOTFORREPLICATION]
]
|CHECK[NOTFORREPLICATION]
(logical_expression)
}
::=[CONSTRAINTconstraint_name]
{
[{PRIMARYKEY|UNIQUE}
[CLUSTERED|NONCLUSTERED]
{(column[,...n])}
[WITHFILLFACTOR=fillfactor]
[ON{filegroup|DEFAULT}]
]