云南大学《数据库原理》chapter 5 Integrity, Views, Security, and Catalogs-bcm.pptVIP

Integrity,Views,Security,and Catalogs * 7.1 Integrity Constraints 修改触发器(SQL SERVER) alter trigger tgr_message on student after delete as raisError(tgr_message触发器被触发, 16, 10); --查询已存在的触发器(SQL SERVER) select * from sys.triggers; select * from sys.objects where type = TR; --查看创建触发器语句 exec sp_helptext tgr_message; Integrity,Views,Security,and Catalogs * 7.2 Creating Views View idea ? The data retrieved by any SQL SELECT statement is in the form of a table. We want to use this TABLE in FROM clause of other Select statement. Method Subquery in the FROM clause (Figure 3.11, pg 117) Creating Views