创建 SQL 身份作为主键?
it1352
帮助1人
问题说明
create table ImagenesUsuario
{
idImagen int primary key not null IDENTITY
}
这不起作用.我该怎么做?
This doesn't work. How can I do this?
正确答案
#1
只需对语法进行简单的更改即可:
Simple change to syntax is all that is needed:
create table ImagenesUsuario (
idImagen int not null identity(1,1) primary key
)
通过显式使用constraint"关键字，您可以为主键约束指定一个特定名称，而不是依赖 SQL Server 自动分配名称:
By explicitly using the "constraint" keyword, you can give the primary key constraint a particular name rather than depending on SQL Server to auto-assign a name:
create table ImagenesUsuario (
idImagen int not null identity(1,1) constraint pk_ImagenesUsario primary key
)
如果根据您对表的使用情况最有意义，请添加CLUSTERED"关键字(即，搜索特定 idImagen 和写入量的平衡超过了通过其他索引对表进行聚类的好处).
Add the "CLUSTERED" keyword if that makes the most sense based on your use of the table (i.e., the balance of searches for a particular idImagen and amount of writing outweighs the benefits of clustering the table by some other index).
这篇好文章是转载于：学新通技术网
