Snowflake Vs MS-SQL - Part 98 - Create Table If Not Exists


Create Table If Not Exists

Whenever we are creating a new table, we must verify that the table is not already present.

MS-SQL Server

We can achieve it as follows:



In Snowflake,  we can use it as follows:





For more details, refer to the CREATE TABLE section.

Also, please refer to the earlier article on Create Table - LINK.


Location: Pune, Maharashtra, India

Comments

Post a Comment

Popular posts from this blog

Snowflake Vs MS-SQL - Part 70 - UNION By Name

Image
        UNION By Name Sometimes, we have to combine data from multiple tables. In this case, we can use UNION. However, the catch is that the order of the columns should be the same. MS-SQL Server   We can achieve this by using UNION as below: In  Snowflake,  we can use  the same query as above; however, we have to use the same column order in the select clause. However, we can use  UNION BY Name   as below. The order of the columns in the  select clause does not matter. NOTE: Similarly, you can use  UNION ALL BY NAME . For more details, you can refer to the following:  UNION . Yogesh Shinde LinkedInProfile <<< Back   Next >>>  
Read more

Snowflake Vs MS-SQL - Part 68 - Multi Table Insert

Image
         Multi Table Insert We insert data into a table, and sometimes, we must archive/back it up in another table. MS-SQL Server   We can achieve this by using magic or virtual tables present, like INSERTED,  as below: However, in  Snowflake, the insert statement has an additional clause,  INSERT ALL,  which allows you to insert into multiple tables:  For more details, you can refer to the following:  Multi_Table_Insert . Yogesh Shinde LinkedInProfile <<< Back   Next >>>        
Read more

Snowflake Vs MS-SQL - Series

Image
Snowflake Vs MS-SQL - Series Part 97 -  Identify Data Type - SYSTEM$TYPEOF   -  Part 97 Part 96 -  Row Last Updated - ROW_TIMESTAMP   -  Part 96 Part 95 -  Date and Time - INTERVAL   -  Part 95 Part 94 -  BOOLAND_AGG   -  Part 94 Part 93 -  MERGE ALL BY NAME   -  Part 93 Part 92 -  Stop or Cancel the Running Query   -  Part 92 Part 91 -  ARRAY UNNEST - FLATTEN   -  Part 91 Part 90 -  Replace the String - INSERT - STUFF  -  Part 90 Part 89 -  Form the DATE from Parts DATE_FROM_PARTS  -  Part 89 Part 88 -  Count of non-NULL records of the column using ILIKE  -  Part 88 Part 87 -  UTC Time - CONVERT TIMEZONE  -  Part 87 Part 86 -  Modulus/Modulo Function - Remainder  -  Part 86 Part 85 -  UNION ALL BY NAME  -  Part 85   Part 84 -  EXTRACT Day/Month/Year  -  Part 84 Part 83 -...
Read more