Q. What column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE '%name';
-
(A)
suffixed with 'name'
-
(B)
prefixed with 'name'
-
(C)
suffixed with '%name'
-
(D)
prefixed with '%name'
✅ Correct Answer: (A)
suffixed with 'name'
Explanation: This SQL command is used to get information about the columns of a table.