当前位置: 代码迷 >> Sql Server >> Sqlserver菜鸟
  详细解决方案

Sqlserver菜鸟

热度:97   发布时间:2016-04-27 13:36:35.0
Sqlserver初学者
我刚接触这个数据库,现在老师上课讲到创建表,,有两种方法,一种直接什么。。。还有就是用sql语句,我看第一句中方法很方便,为什么还要学习第二种,虽然现在还没开始学习第二种方法,

------解决方案--------------------
第一种是手工操作,通过微软件提供的工具创建.
第二种是SQL语句操作,一般是在程序中使用.所以如果是软件开发人员,应该掌握这种方法.
其相关内容见下:
SQL code
CREATE TABLE创建新表。语法CREATE TABLE    [ database_name.[ owner ] .| owner.] table_name    ( { < column_definition >        | column_name AS computed_column_expression        | < table_constraint > ::= [ CONSTRAINT constraint_name ] }            | [ { PRIMARY KEY | UNIQUE } [ ,...n ]    ) [ ON { filegroup | DEFAULT } ] [ TEXTIMAGE_ON { filegroup | DEFAULT } ] < column_definition > ::= { column_name data_type }    [ COLLATE < collation_name > ]    [ [ DEFAULT constant_expression ]        | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]    ]     [ ROWGUIDCOL]    [ < column_constraint > ] [ ...n ] < column_constraint > ::= [ CONSTRAINT constraint_name ]    { [ NULL | NOT NULL ]        | [ { PRIMARY KEY | UNIQUE }            [ CLUSTERED | NONCLUSTERED ]            [ WITH FILLFACTOR = fillfactor ]            [ON {filegroup | DEFAULT} ] ]        ]         | [ [ FOREIGN KEY ]            REFERENCES ref_table [ ( ref_column ) ]            [ ON DELETE { CASCADE | NO ACTION } ]            [ ON UPDATE { CASCADE | NO ACTION } ]            [ NOT FOR REPLICATION ]        ]         | CHECK [ NOT FOR REPLICATION ]        ( logical_expression )     } < table_constraint > ::= [ CONSTRAINT constraint_name ]    { [ { PRIMARY KEY | UNIQUE }        [ CLUSTERED | NONCLUSTERED ]        { ( column [ ASC | DESC ] [ ,...n ] ) }        [ WITH FILLFACTOR = fillfactor ]        [ ON { filegroup | DEFAULT } ]    ]     | FOREIGN KEY        [ ( column [ ,...n ] ) ]        REFERENCES ref_table [ ( ref_column [ ,...n ] ) ]        [ ON DELETE { CASCADE | NO ACTION } ]        [ ON UPDATE { CASCADE | NO ACTION } ]        [ NOT FOR REPLICATION ]    | CHECK [ NOT FOR REPLICATION ]        ( search_conditions )     }
------解决方案--------------------
探讨
大哥好强大啊
  相关解决方案