在数据库中创建数据表时，根据旧表创建新表的Sql怎么写？

 我来答

1个回答

#合辑# 机票是越早买越便宜吗？

桓增岳那璧
2019-06-26 · TA获得超过3.7万个赞

知道大有可为答主

回答量：1.2万

采纳率：34%

帮助的人：1075万

我也去答题访问个人页

关注

展开全部

楼主真懒,
这些东西百度一下都有的:
execute
sp_configure'show
advanced
options',1
reconfigure
execute
sp_configure
'xp_cmdshell',1
reconfigure
execute
xp_cmdshell
'mkdir
e:\aaa'
execute
sp_configure
'xp_cmdshell',0
reconfigure
execute
sp_configure
'show
advanced
options',0
reconfigure
--
创建数据库
impression
create
database
impression
on
primary
(
name
=
'impression',
filename
=
'e:\aaa\impression.mdf',
size
=
5,
maxsize
=
unlimited,
filegrowth
=
5
)
log
on
(
name
=
'impression_log',
filename
=
'e:\aaa\impression_log.ldf',
size
=
1,
maxsize
=
unlimited,
filegrowth
=
10%
)
go
--
创建
teacher
表
create
table
teacher
(
id
int
identity(1,1),
name
nvarchar(30),
sex
bit,
birthday
date,
telephone
nvarchar(15),
address
nvarchar(100),
email
nvarchar(100)
)
go
--
给表teacher添加，邮编
字符类型，长度6一列
alter
table
teacher
add
zipcode
nvarchar(6)
go
--
给表teacher
，字段id添加主键
alter
table
teacher
add
constraint
pk_id
primary
key
(id)
go
--
创建索引i_teacher,优化字段email和address
create
index
i_teacher
on
teacher
(email,address)
go
--
创建v_teacher视图
???
这个问题没有规定视图中有什么列啊?
create
view
v_teacher
as
(
select
*
from
teacher
)
go
--
删除id字段主键
alter
table
teacher
drop
constraint
pk_id
--
删除索引i_teacher
drop
index
i_teacher
on
teacher
--
删除视图v_teacher
drop
view
v_teacher
--
删除表teacher
drop
table
teacher
--
删除数据库impression
drop
database
impression