📄 create view2.sql

📁 本程序中即有讲义

💻 SQL

字号:

USE pubs 
go
CREATE VIEW CAonly AS 
SELECT au_lname, au_fname, city, state FROM authors 
WHERE state = 'CA'
 WITH CHECK OPTION
go
select * from caonly
select * from caonly where city like '[sv]%'

--select * from caonly where city = '[sv]%'

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -