34,591
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #t
(
id INT IDENTITY(1,1) PRIMARY KEY,
sname VARCHAR(20)
)
insert #t values('美丽人生')
insert #t values('love yao')
select * from #t
id sname
----------- --------------------
1 美丽人生
2 love yao
(2 row(s) affected)
CREATE TABLE #t2
(
id int,
sname NVARCHAR(20)
)
alter table #t2
add constraint PK_ID PRIMARY KEY (ID)
alter table tablename
alter colunm colunmname identity(1,1)
CREATE TABLE #t3
(
id int,
sname NVARCHAR(20)
)
insert #t3 values(1,'abc1')
insert #t3 values(3,'abc2')
insert #t3 values(43,'abc3')
insert #t3 values(23,'abc4')
select * from #t3
go
alter table #t3
drop column id
alter table #t3
add ID int identity(1,1)
select * from #t3
go
CREATE TABLE tb
(
id INT IDENTITY(1,1) PRIMARY KEY,
)
ALTER TABLE tb
ADD CONSTRAINT PK_id PRIMARY KEY (id)
alter table tb
drop constraint PK_id
CREATE TABLE tb
(
id INT IDENTITY(1,1) PRIMARY KEY,
name VARCHAR(20)
)