通过ADO可以访问SQLSERVER，并执行相应的SQL语句建库、建表，下面是SQLSERVERBOOKSONLINE中的相关定义。

建表：

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}]

]

|FOREIGNKEY

[(column[,...n])]

REFERENCESref_table[(ref_column[,...n])]

[NOTFORREPLICATION]

|CHECK[NOTFORREPLICATION]

(search_conditions)

}

建库：

CREATEDATABASEdatabase_name

[ON[PRIMARY]

[[,...n]]

[,[,...n]]

]

[LOGON{[,...n]}]

[FORLOAD|FORATTACH]

::=

([NAME=logical_file_name,]

FILENAME='os_file_name'

[,SIZE=size]

[,MAXSIZE={max_size|UNLIMITED}]

[,FILEGROWTH=growth_increment])[,...n]

::=

FILEGROUPfilegroup_name[,...n]