Answers for "desc table"

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';

Posted by: Guest on February-25-2020

describe table in sql

desc <table name>;

Posted by: Guest on December-07-2020

Code answers related to "desc table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "desc table"

Code answers related to "desc table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "desc table"

Code answers related to "desc table"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us