Sql

USE YOUR_DATABASE_NAME
SELECT *
FROM INFORMATION_SCHEMA.TABLES

SELECT *
FROM INFORMATION_SCHEMA.tables
where table_schema = 'public';

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

USE 'DATABASE_NAME';

SHOW TABLES;

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = table_name;

PREVIOUS	NEXT

Code Example
Sql :: select count of distinct values sql
Sql :: postgres first_value in gropby
Sql :: psql: FATAL: Ident authentication failed for user "postgres"
Sql :: alter table oracle
Sql :: how to check schema privileges in oracle
Sql :: grant mysql
Sql :: SQLite order random
Sql :: oracle alter tablespace add datafile autoextend max size
Sql :: what is mysql_pconnect
Sql :: find wordpress version in database
Sql :: insert pg result of select
Sql :: where clause for child record apex
Sql :: mysql python
Sql :: mysql select column where has non int values
Sql :: make a field auto_increment mysql
Sql :: docker run mysql image
Sql :: id increment ms sql server
Sql :: simple project for database
Sql :: sql add column int nullable
Sql :: get ip from phpmyadmin
Sql :: sql rank
Sql :: order by sql
Sql :: how to add CHECK constraint to a column in postgres
Sql :: how to create enum in postgresql
Sql :: what is integrity constraints
Sql :: update value postgresql
Sql :: sql limit results returned
Sql :: load sql into mamp
Sql :: postgresql get difference between two dates
Sql :: mysql create database utf8