File: create_table_like_copy_clone.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (21 lines) | stat: -rw-r--r-- 450 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
CREATE TABLE mydataset.newtable
LIKE mydataset.sourcetable
;

CREATE TABLE mydataset.newtable
LIKE mydataset.sourcetable
AS SELECT * FROM mydataset.myothertable
;

CREATE TABLE mydataset.newtable
COPY mydataset.sourcetable
;

CREATE TABLE mydataset.newtable_clone
CLONE mydataset.sourcetable
;

CREATE TABLE IF NOT EXISTS mydataset.newtable_clone
CLONE mydataset.sourcetable FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP()
OPTIONS(description="example")
;