Select from describe sql

SELECT COLUMN_NAME AS `Field`, COLUMN_TYPE AS `Type`, IS_NULLABLE AS `NULL`, 
       COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS `Extra`
FROM information_schema.COLUMNS  
WHERE TABLE_SCHEMA = 'schemaName' AND TABLE_NAME = 'table1';

Source: stackoverflow.com

Similar codes

0 vote263 views1 answer
Hierarchal database table
SQL
0 vote217 views2 answers
How to know the character set of an oracle databes
SQL
0 vote204 views1 answer
Set open file limit mac catalina mysql
SQL
2 votes205 views1 answer
Mysql query unique column
SQL
0 vote220 views1 answer
What is initial catalog in sql connection string
SQL
0 vote215 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
2 votes222 views1 answer
Power query concatenate
SQL
0 vote202 views1 answer
Find invalid datetime field
SQL
1 vote206 views1 answer
How to use db.execute
SQL
3 votes226 views5 answers
Foreign keys
SQL