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 :: Remove mySQL from ubuntu 20.x
Sql :: this month mysql where
Sql :: Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
Sql :: alter table column size oracle
Sql :: list tables sqlite
Sql :: mysql group by month
Sql :: how to increase size of column in sql
Sql :: postgres alter user password
Sql :: sql server version query
Sql :: set mysql mode global query
Sql :: sql delete multiple ids
Sql :: sql add date hour
Sql :: how to remove characters from string in mysql
Sql :: wordpress sql find and replace
Sql :: reset identity column in sql server
Sql :: sql server get timezone
Sql :: mssql show database size
Sql :: microsoft sql server extract hour and minute from datetime
Sql :: insert column with default value in sql
Sql :: find last instance of character in string mysql
Sql :: how to list function in psql
Sql :: list all permissions on a table in postgres
Sql :: mysql date greater than 30 days
Sql :: django sqlite database
Sql :: alter sequence restart with postgresql
Sql :: postgres remove foreign key constraint
Sql :: zerar auto increment mysql
Sql :: dual table in aql
Sql :: operator does not exist: integer = text
Sql :: delete all rows from table mysql