怎样用ADO在SQL SERVER中建库，建表

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

建表：

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)

}