日期:2011-01-25 23:11:00 来源:本站整理
利用ADO在sql server建表的办法[MSSQL防范]
本文“利用ADO在sql server建表的办法[MSSQL防范]”是由七道奇为您精心收集,来源于网络转载,文章版权归文章作者所有,本站不对其观点以及内容做任何评价,请读者自行判断,以下是其具体内容:
通过ADO可以拜候sql server,并且实现sql server建表,下面为您介绍利用ADO在sql server建表的办法,供您参考,但愿对您学习sql server建表有所帮忙.
<
- 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)
- }
以上是“利用ADO在sql server建表的办法[MSSQL防范]”的内容,如果你对以上该文章内容感兴趣,你可以看看七道奇为您推荐以下文章:
本文地址: | 与您的QQ/BBS好友分享! |
评论内容只代表网友观点,与本站立场无关!
评论摘要(共 0 条,得分 0 分,平均 0 分)
查看完整评论