MySQL

MySQL: Table size query

Posted on

    SELECT TABLE_NAME, table_rows, data_length, index_length, ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’ FROM information_schema.TABLES WHERE table_schema = ‘mallagroup_mautic’ ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC ;

PostgreSQL

PgSql: Create table inside database

Posted on

Example   CREATE TABLE c_ordernotes ( c_ordernotes_id numeric(10,0) CONSTRAINT firstkey PRIMARY KEY, ad_client_id numeric(10,0) NOT NULL, ad_org_id numeric(10,0) NOT NULL, isactive character(1), created timestamp DEFAULT current_timestamp, createdby numeric(10,0), updated timestamp DEFAULT current_timestamp, updatedby numeric(10,0), c_order_id numeric(10,0), line numeric(10,0), notes_name varchar(255), notes_description varchar(2550) );