blob: 00a7e519bf61ec037a7067be19f4588eff1be62c (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
# WITHOUT
Excluding columns from the result of `SELECT *`. The `IF EXISTS` modifier does not throw an error for missing columns.
## Examples
```yql
SELECT * WITHOUT foo, bar FROM my_table;
SELECT * WITHOUT IF EXISTS foo, bar FROM my_table;
```
```yql
PRAGMA simplecolumns;
SELECT * WITHOUT t.foo FROM my_table AS t
CROSS JOIN (SELECT 1 AS foo) AS v;
```
|
