SQL Server怎样用ADO在SQL SER5ER中建库建表

作者:袖梨 2023-08-14

通过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] 

相关文章

精彩推荐