{"id":21927,"date":"2016-06-10T08:08:01","date_gmt":"2016-06-10T08:08:01","guid":{"rendered":"https:\/\/www.testingdocs.com\/questions\/?p=21927"},"modified":"2024-12-16T14:25:45","modified_gmt":"2024-12-16T14:25:45","slug":"sql-statement-to-view-the-table-columns-and-settings","status":"publish","type":"post","link":"https:\/\/www.testingdocs.com\/questions\/sql-statement-to-view-the-table-columns-and-settings\/","title":{"rendered":"SQL statement to view the table columns and settings"},"content":{"rendered":"

Q) Let’s consider the database table City from the world MySQL database. What are the correct SQL statements to view the table columns and settings?<\/strong><\/p>\n

a) DESC City;
\nb) VIEW City;
\nc) DESCRIBE City;
\nd) SHOW City;<\/p>\n

Choose the correct options.<\/p>\n

Answer Explanation<\/h2>\n

The options b and d are NOT<\/strong> correct. The statements are not valid SQL statements.
\nThey result in the following error.<\/p>\n

mysql> VIEW City;<\/em>
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘VIEW City’ at line 1<\/p>\n

Hence, options b and d are incorrect options.<\/p>\n

Correct Answer<\/h2>\n

The options a and c are correct.<\/p>\n

DESCRIBE statement is used to show the list of table column names and other settings. We can also use the short-form DESC for the command.<\/p>\n

Syntax:
\nDESCRIBE <table_name>;
\nor
\nDESC <table_name>;<\/p>\n

To view the City table columns and settings, we can use the following statements.<\/p>\n

mysql> DESC City;<\/em><\/p>\n

mysql> DESCRIBE City;<\/em>
\n+————-+———-+——+—–+———+—————-+
\n| Field | Type | Null | Key | Default | Extra |
\n+————-+———-+——+—–+———+—————-+
\n| ID | int | NO | PRI | NULL | auto_increment |
\n| Name | char(35) | NO | | | |
\n| CountryCode | char(3) | NO | MUL | | |
\n| District | char(20) | NO | | | |
\n| Population | int | NO | | 0 | |
\n+————-+———-+——+—–+———+—————-+
\n5 rows in set (0.00 sec)<\/p>\n

 <\/p>\n

\"Table<\/p>\n

Hence, a and c are correct options.<\/strong><\/p>\n

—<\/p>\n

MySQL Tutorials<\/h2>\n

MySQL Tutorials on this website:<\/p>\n

https:\/\/www.testingdocs.com\/mysql-tutorials-for-beginners\/<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Q) Let’s consider the database table City from the world MySQL database. What are the correct SQL statements to view the table columns and settings? a) DESC City; b) VIEW City; c) DESCRIBE City; d) SHOW City; Choose the correct options. Answer Explanation The options b and d are NOT correct. The statements are not […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[520],"tags":[],"class_list":["post-21927","post","type-post","status-publish","format-standard","hentry","category-mysql-database","has-post-title","has-post-date","has-post-category","has-post-tag","has-post-comment","has-post-author",""],"_links":{"self":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/comments?post=21927"}],"version-history":[{"count":12,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21927\/revisions"}],"predecessor-version":[{"id":26490,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/posts\/21927\/revisions\/26490"}],"wp:attachment":[{"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/media?parent=21927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/categories?post=21927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testingdocs.com\/questions\/wp-json\/wp\/v2\/tags?post=21927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}