T-SQL 对表结构进行增，删，改

192 阅读 0 评论 127 点赞

我是靠谱客的博主高贵大碗，这篇文章主要介绍T-SQL 对表结构进行增，删，改，现在分享给大家，希望可以做个参考。

create database test1use test1create table admin( id int primary key , name varchar(50), pwd varchar(50),)insert into admin values(1,'aa','aa')alter table admin add...

create database test1
use test1
create table admin
(
   id int primary key ,
   name varchar(50),
   pwd  varchar(50),
)
insert into admin values(1,'aa','aa')
alter  table   admin   add   tel  varchar(50)   NULL
select * from admin

select * from admin
if   exists   (select   *   from   syscolumns   where   id=object_id('admin')   and   name='mms')   print   '已经存在该字段'
alter  table   admin   add   tel  varchar(50)   NULL

alter table admin alter column name set bbs varchar(50) null
alter table tablename  drop column oldfield

EXEC sp_rename 'admin.sss', 'tel', 'COLUMN'