SQL

CREATE TABLE

CREATE TABLE users ( ) 

create-table

create table bricks (
  colour varchar2(10),
  shape varchar2(10)
);

select table_name
from   user_tables
where  table_name = 'BRICKS';

create table

CREATE TABLE fact (
id SERIAL PRIMARY KEY NOT NULL,
type VARCHAR(255),
text TEXT
);

create table

create table FROM world as
SELECT name, population BETWEEN 1000000 AND 1250000

Create a table

CREATE TABLE history (
author VARCHAR(128),
title VARCHAR(128),
type VARCHAR(16),
year CHAR(4)) ENGINE InnoDB;

create table

rollNo INT
studentName VARCHAR(50)
branch VARCHAR(10)
semester INT

Creating table

create table bricks (
  colour VARCHAR2(10),
  shape VARCHAR2(10)
);

select table_name
from   user_tables
where  table_name = 'BRICKS';