SQL Commands and Typs

 

We can create database using webUI, , SnowSQL, SQL etc..

SQL :

• DDL
• Create 
• Drop
• Alter
• Truncate
• DCL
• Grant
• Revoke
• DML
• Insert
• Update
• Delete
• TCL
• Commit
• Rollback
• Save Point
• DQL
• Select

supported types: https://docs.snowflake.com/en/sql-reference/intro-summary-data-types.html

DDL Tables :

Create : 

create or replace TABLE TRAINING.DEMO.SAMPLE_TBL (

"id" NUMBER(38,0) NOT NULL,

NAME VARCHAR(16777216) NOT NULL

);

ALTER :

ALTER TABLE sample_tbl

ADD column sal double;

drop table 

DROP TABLE sample_tbl;

TRUNCATE :

truncate table SAMPLE_TBL;

show tables;

select get_ddl('table', 'SAMPLE_TBL');

INSERT  INTO SAMPLE_TBL values (100,'Murali');

select * from sample_tbl;