Sql

SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE '%column_name_to_search%';

PREVIOUS	NEXT

Code Example
Sql :: group_concat in mysql
Sql :: mysql compare datetime to another datetime
Sql :: mysql date range
Sql :: mysql full outer join
Sql :: call function sql oracle
Sql :: sql date format
Sql :: sql select most frequent value in column
Sql :: read all columns of a table sql
Sql :: joomla execute raw sql
Sql :: left join in codeigniter query builder
Sql :: update table disable constraint
Sql :: current timestamp in milliseconds mysql
Sql :: check table exist postgresql
Sql :: codigo crear tablas sql server
Sql :: SQL Error 1040 : Too many connections
Sql :: how to enable extension in postgreSQL
Sql :: create function syntax sql server
Sql :: mysql money value
Sql :: postgresql delete limit
Sql :: create database in mysql
Sql :: launch sql script from docker in mysql
Sql :: mysql remove first and last character from string
Sql :: date in oracle
Sql :: sql round 2 decimal
Sql :: com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
Sql :: execute sp in sql server
Sql :: mysql auerries to find the name starting with vowel letter
Sql :: q operator in sql
Sql :: drush run sql select
Sql :: datepart sql server