sql sever基本命令

 

创建表：
create table stu_info(
id int identity(1,1) not null primary key clustered,
name char(10) not null,
score numeric not null
)

新建主键：
create table stu_info(
id int identity(1,1) not null,
name char(10) not null
)
alter table stu_info add constraint pk_id primary key cluster (id)

新建表字段
alter table stu_info add sex char(10) not null
删除表字段
alter table stu_infor drop column score
插入数据
insert into stu_info1 (name,score) values('a1',10)
更新数据
update stu_info1 set name='a2' where id =1
删除数据
delete stu_info1 where name='a1'
查询数据
select * from stu_info1

创建索引以及删除
create index stu_index on stu_info(id)
create unique stu_index on stu_info(id)
drop index stu_index on stu_info

修改表名
exec sp_name 'old_name','new_name'
修改列名称
exec sp_name 'test.old_column_name','new_column_name','column'

修改列类型
alter table test alter column test1 numeric(4,2)

 

转载于:https://www.cnblogs.com/Dai-py/p/10728091.html