创建视图

线体6005

创建客户号是3位数字开头，第4位是空格的视图

CREATE VIEW v_VW as
select id_stocpf,et_refcmp,et_qualpf,stocpf_no_cli,datemodif from t_stocpf where stocpf_no_cli ~'^\d{3}\s';

删除视图

DROP VIEW v_vw