数据库有种视图具体语法 if exists(select *from sysobjects where name ='cc')drop view ccgocreate view ccasselect cardid as 卡号,curtype as 货市类型,savingtype as 存款类型,opendate as 开户日期,balance as 余额,pass as 密码,isreportloss as 是否挂失,customerid as 客户编号 from cardinfogoselect * from cc |