Question: How can you list all columns for a given table?

1. SHOW table COLUMNS;
2. SHOW COLUMNS FROM table;
3. LIST table COLUMNS;
4. SELECT COLUMNS FROM table;

Answer: The correct answer of the above question is Option B:SHOW COLUMNS FROM table;