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

2 votes308 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote356 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote339 views1 answer
Reona
SQL
23 votes348 views6 answers
How to create table in sql
SQL
1 vote315 views1 answer
Mysql date diff in seconds
SQL
0 vote360 views1 answer
How to install sql in anaconda
SQL
0 vote323 views1 answer
Mysql order by where condition sub query
SQL
0 vote346 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote353 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote319 views1 answer
Funzioni plsql
SQL