create table
( a varchar(10) not null,
b char(3)
primary key (a)
)
( a varchar(10) not null,
b char(3)
primary key (a)
)
解决方案 »
- 新手请教问题。
- 表数据追加插入SQL
- 发生错误1722(RPC服务器不可用),此时正在sql server Agent服务上执行该服务操作
- 求SQL多表连接查询并统计求和的语句~~~~???急!!对的~~即给分~~限时两天!
- 求一份关于传动轴突缘叉 CA10B解放牌汽车 零件号831014 夹具装配图 零件图 机械加工工序卡片 机械加工工艺过程卡片等
- 有关于insert的一个问题?在线等候
- 请教,索引有什么用?怎么用
- 在Access2000数据库中打开链接到sql的链接表时,老是要输入sql的连接密码,有没有办法建立后访问不需要密码了?
- 还是SQL SERVER 的。如果顺利当天结分
- 各位大侠!Net8 Configuration Assistant 进行本地网络服务名配置问题!
- 在SQL Server 7.0中关于datatime类型数据的问题
- 能不能在触发器里面写动态SQL语句中支持inserted对象
(
item_id smallint
IDENTITY(1,1)
PRIMARY KEY CLUSTERED
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 )
}
help 有各种示例