创建索引和视图.sql

QL SERVER 应用开发 银行ATM(取款机）系统 数据库设计 我在学校的 SQL项目,模拟 银行ATM(取款机）系统

use bankDB
GO
--创建索引：
if exists (select * from sysindexes where name='index_transInfo_cardID')
drop index transInfo.index_transInfo_cardID
GO
create nonclustered index index_transInfo_cardID
on transInfo(cardID)
with fillfactor=70
GO
select * from transInfo(index=index_transInfo_cardID) where cardID='1010 3576 1234 5678'
GO

--创建视图：
create view view_userInfo
as
select 客户编号=customerID,开户名=customerName,身份证号=PID,电话号码=telephone,居住地址=address from userInfo
GO
create view view_cardInfo
as
select 卡号=cardID,货币种类=curType,存款类型=savingType,开户日期=openDate,开户金额=openMoney,余额=balance,密码=pass,是否挂失=IsReportLoss,顾客编号=customerID from cardInfo
GO
create view view_transInfo
as
select 交易日期=transDate,卡号=cardID,交易类型=transType,交易金额=transMoney,备注=remark from transInfo
GO
select * from view_userInfo
select * from view_cardInfo
select * from view_transInfo
GO