表名：ZL_View

简要说明：

ZL_View

GO

Create View [dbo].[ZL_View] AS 

SELECT A.*,B.SchoolName,C.GradeName,D.UserName FROM ZL_Exam_ClassRoom A LEFT JOIN ZL_School B ON A.SchoolID=B.ID LEFT JOIN ZL_Grade C ON C.GradeID=A.Grade LEFT JOIN ZL_User D ON D.UserID=A.CreateUser


--注意：将清空全表数据

detele from ZL_View

--注意：将删除整个表

drop table ZL_View

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_View