通过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]
【SQL Server--怎样用ADO在SQL SERVER中建库，建表】相关文章：