File: parseCreateViewMultiple.in

package info (click to toggle)
phpmyadmin-sql-parser 5.10.3-1~bpo12%2B1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm-backports
  • size: 16,868 kB
  • sloc: php: 52,916; makefile: 13; sh: 8
file content (18 lines) | stat: -rw-r--r-- 464 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
CREATE TABLE T1 (COL1 CHAR(10))

CREATE VIEW  V1 AS SELECT COL1
    FROM T1 WHERE COL1 LIKE 'A%'

CREATE VIEW V2 AS SELECT COL1
    FROM V1 WHERE COL1 LIKE '%Z'
                            WITH LOCAL CHECK OPTION

CREATE VIEW V3 AS SELECT COL1
    FROM V2 WHERE COL1 LIKE 'AB%'

CREATE VIEW V4 AS SELECT COL1
    FROM V3 WHERE COL1 LIKE '%YZ'
                            WITH CASCADED CHECK OPTION

CREATE VIEW V5 AS SELECT COL1
    FROM V4 WHERE COL1 LIKE 'ABC%'