SQL Server--怎樣用ADO在SQL SERVER中建庫，建表

2024-05-04 11:03:04

字體：大中小

來源：轉載

供稿：網友

通過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} ]
    ]

上一篇：jb51生成所有頁面的效果+分頁生成原創

下一篇：在線管理數據庫類