Exam SOL-C01 Topic 1 Question 211 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 211
Topic #: 1
Which SQL command is used to view the definition of a Table?

Suggested Answer: B Vote an answer

TheGET_DDLfunction retrieves the Data Definition Language (DDL) script that was used to create a given object. Executing:
SELECT GET_DDL('TABLE', 'MY_TABLE');
returns the full DDL including column definitions, comments, clustering keys, constraints, masking policies, and other metadata. This makes it essential for schema migration, replication, compliance audits, and environment synchronization.
DESCRIBE TABLEshows only column-level metadata-names, types, nullability-but does not return the full DDL.
SHOW TABLEis not a valid Snowflake command; tables are listed using SHOW TABLES.
INFORMATION_SCHEMA.TABLES lists table metadata, but the provided option "ABLES" is invalid and still would not provide DDL even if corrected.
Thus,GET_DDL()is the only method that returns the complete table definition directly.

by Hedy at Dec 08, 2025, 07:06 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10