What are the types of tables in SQL?

Here are the types of tables in SQL given:-

A Heap Table ( Standard Table) is a regular or day-to-day table where data is stored without any specific order. The SQL command of this is:-

CREATE TABLE Table name( 

       Column1 DataType,

        Column2 DataType,

        …

);

A clustered Table is a table in which data is stored based on sorted. The command of it is

CREATE TABLE TableName ( 

Clustering column DataType,

Other column DataType,

…

PRIMARY KEY (clusteringcolumn));

A partitioned Table Is a table that is used to improve manageability and performance. The SQL command of it is:-

CREATE TABLE TableName (

      …

) PARTITION BY RANGE (PartitionColumn)(

    PARTITION P1 VALUES LESS THAN (value),

    PARTITION P2 VALUES LESS THAN (value),

    …

);

Temporary Table is used to hold the data in temporary form. Here is the SQL command for it

CREATE TEMPORARY TABLE TableName (

…

);

Materialized View is a physical table to improve the performance of the query. The command of it is

CREATE MATERIALIZED VIEW ViewName AS

SELECT columns 

FROM tables

FROM conditions ;

Global Temporary Table, in which the stored data is accessible to all sessions. The SQL command of it is

“CREATE GLOBAL TEMPORARY TABLE TableName (

…

);

Level up your career with MSBI training & certification! Start your journey to success today. Enroll now and unleash your full potential!