USE test1;
CREATE TABLE S
( [name] nvarchar ( 10 ) NOT NULL,
age FLOAT NOT NULL,
id VARCHAR ( 10 ) PRIMARY KEY,
sex nvarchar ( 1 ) )
ALTER TABLE S
ALTER COLUMN [name] nvarchar(15);
ALTER TABLE S
ALTER COLUMN age float;
ALTER TABLE S
ALTER COLUMN sex nvarchar(1) not null;
use test1
sp_columns S1;
alter table S1
alter column [name] nvarchar(10);
alter table S1
alter column age int;
alter table S1
alter column age int not null;
alter table S1
add score1 numeric(3, 1), score2 numeric(3, 1), score3 numeric(3, 1), grade int not null default 1
alter table S1
add constraint S1_Pri primary key (id);
alter table S1
EXEC sp_rename 'S1.age', 'sAge', 'column';