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

80酷酷网    80kuku.com

  

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

}

建库:

CREATE DATABASE database_name

[ ON [PRIMARY]

[ [,...n] ]

[, [,...n] ]

]

[ LOG ON { [,...n]} ]

[ FOR LOAD | FOR ATTACH ]

::=

( [ NAME = logical_file_name, ]

FILENAME = ’os_file_name’

[, SIZE = size]

[, MAXSIZE = { max_size | UNLIMITED } ]

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

::=

FILEGROUP filegroup_name [,...n]


 

分享到
  • 微信分享
  • 新浪微博
  • QQ好友
  • QQ空间
点击: