创建数据库,如果存在则先删除再创建
USE master
GO
IF EXISTS(
SELECT name
FROM sys.databases
WHERE name = N'teaching'
)
DROP DATABASE teaching
创建数据表,如果存在则先删除再创建
IF EXISTS (
SELECT *
FROM sys.objects
WHERE name = N'student'
)
DROP TABLE student
创建索引,如果存在,则先删除再创建
IF EXISTS(
SELECT name
FROM sys.indexes
where name='IDX_sc'
)
drop index student.IDX_sc
go
创建索引时,默认创建的是不唯一,非聚集索引
创建索引:create index 索引名 on student(studentno,sname)
创建视图: use teaching
go
create view 视图名
as
select *
from course
where type='必修'