html5中文学习网

您的位置: 首页 > 网络编程 > ASP编程 » 正文

怎样用ADO在SQL SERVER中建库,建表_ASP教程_编程技术

[ ] 已经帮助:人解决问题

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


 

7JDHTML5中文学习网 - HTML5先行者学习网
7JDHTML5中文学习网 - HTML5先行者学习网
(责任编辑:)
推荐书籍
推荐资讯
关于HTML5先行者 - 联系我们 - 广告服务 - 友情链接 - 网站地图 - 版权声明 - 人才招聘 - 帮助