????1????????Scores
1 create table Scores               --????
2 (Id int identity(1??1) primary key??--???????????????к???????
identity(1??1)???Id?д?1????????????????1
3 Date datetime not null??           --?????????datetime?????????
4 Name nvarchar(50) not null??
5 Score nvarchar(2)                 --??????£????????
6 )
????2????????Scores?NewScores
????1 exec sp_rename ' Scores ' ?? ' NewScores '
????3???????Scores
????1 drop table Scores --???????????????????????????????
????4??????????
????1 truncate table Scores --???????????е?????
????5???????Score? not null
????1 alter table Scores
????2 alter column Score nvarchar(2) not null
????6???????
????1 alter table Scores
????2 add new nvarchar(20) not null
????7?????????
????1 exec sp_rename 'Scores.Name'??'NewName'??'column'
????8???????
????1  alter table Scores
????2  drop column new
????9?????identity??
???????????????????????????С?????????в?????????????????Id???????????????????о???identity?????Id??Ρ?
1  exec sp_pkeys @table_name='Scores'                               --?????????
2  alter table Scores drop constraint PK__Scores__3214EC074E3D66D2  --?????????????
3  alter table Scores drop column Id                                --??Id????
4  alter table Scores add Id int identity(1??1)                      --?????????(???Id?в???????)
5  alter table Scores add Id int identity(1??1) constraint pk primary key  --????????У?????Id??????????pk