CREATE SCHEMA sample_schema_2;
USE SCHEMA sample_schema_2;
CREATE TABLE sample_table_1 (i INTEGER);
CREATE VIEW sample_view_1 AS
SELECT i FROM sample_table_1;
CREATE MATERIALIZED VIEW sample_mview_1 AS
SELECT i FROM sample_table_1 WHERE i < 100;
DESCRIBE SCHEMA sample_schema_2;
+-------------------------------+----------------+-------------------+
| created_on | name | kind |
|-------------------------------+----------------+-------------------|
| 2022-06-23 01:00:00.000 -0700 | SAMPLE_TABLE_1 | TABLE |
| 2022-06-23 02:00:00.000 -0700 | SAMPLE_VIEW_1 | VIEW |
| 2022-06-23 03:00:00.000 -0700 | SAMPLE_MVIEW_1 | MATERIALIZED_VIEW |
+-------------------------------+----------------+-------------------+
Copy
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4