怎樣用ADO在SQL SERVER中建庫,建表

來源:互聯網
上載者:User

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


 



相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。