正在阅读：怎样用ADO在SQL SERVER中建库，建表怎样用ADO在SQL SERVER中建库，建表

2004-02-14 09:33 出处：eNet硅谷动力作者：enet 责任编辑：zwg

怎样用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) }