Sql

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

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = table_name;

PREVIOUS	NEXT

Code Example
Sql :: soql last week
Sql :: Get first name and last name from full name string in SQL
Sql :: sql between
Sql :: row to value to json in sql server
Sql :: sql reverse order of results
Sql :: how to count number of rows in sql
Sql :: regexp in mysql
Sql :: mysql delete database
Sql :: remove auto increment mysql
Sql :: what is the difference between clustered and non-clustered index in sql server
Sql :: AND OR NOT operators sql
Sql :: show sql server database
Sql :: postgresql grant owner to user
Sql :: mysql datetime with timezone offset
Sql :: sql insert column
Sql :: mysql select count
Sql :: sql quote in string
Sql :: mysql utc to local time
Sql :: create table query in mysql
Sql :: inner join
Sql :: mysql case
Sql :: how to upper case in sql
Sql :: /bin/sh: 1: mysql_config: not found
Sql :: to_date postgresql
Sql :: sql run multiple updates in one query
Sql :: add column table pl sql
Sql :: ms sql server port
Sql :: drop database using terminal postgres
Sql :: select case when oracle
Sql :: difference between 2 query results sql server