脚本宝典收集整理的这篇文章主要介绍了SQL Server--怎样用ADO在SQL SERVER中建库,建表,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
通过ADO可以访问
SQL&nbs
p;SERVER,并执行相应的SQL语句建库、建表,下面是SQL SERVER
BookS ONLINE中的相关定义。
建表:
CREATE TABLE
[
database_n
ame.[owner].
| owner.
] table_name
(
{
| column_name AS computed_column_ex
Pression
} [,
...n]
)
[ON {filegroup | DEFAULT} ]
[TEXTIMAGE_ON {filegroup | DEFAULT} ]
::= { column_name data_ty
PE }
[ [ DEFAULT constant_ex
PRession ]
| [ IDENT
ITY [(seed, increment ) [NOT FOR REPLICATION] ] ]
]
[ ROWGU
IDCOL ]
[ ] [ ...n]
::= [CONSTR
aiNT constraint_name]
{
[ NULL | NOT NULL ]
| [ {
Primary KEY |
unique }
[CLUSTE
red | NONCLUSTERED]
[WITH FILLFACTOR = fillfactor]
[ON {filegroup | DEFAULT} }
]
| [ [FOR
eiGN KEY]
REFERENCES ref_table [(ref_column) ]
[NOT FOR REPLICATION]
]
| CHECK [NOT FOR REPLICATION]
(
LOGical_e
xpression)
}
::= [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]
(se
Arch_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]
脚本宝典总结
以上是脚本宝典为你收集整理的SQL Server--怎样用ADO在SQL SERVER中建库,建表全部内容,希望文章能够帮你解决SQL Server--怎样用ADO在SQL SERVER中建库,建表所遇到的问题。
如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。