
Answer-first summary for fast verification
Answer: GET_DDL
The question asks for the SQL command to see the CREATE definition of a masking policy, which means retrieving the complete DDL statement that can recreate the policy. GET_DDL is the correct function for this purpose, as it returns the full CREATE MASKING POLICY statement, including all parameters and the policy body. While DESCRIBE MASKING POLICY (option B) shows the policy body and metadata, it does not provide the complete CREATE statement format. SHOW MASKING POLICIES (option A) and LIST MASKING POLICIES (option D) only list policies without showing their definitions. The community discussion strongly supports C, with high upvotes for comments explaining that GET_DDL returns the full DDL, whereas DESCRIBE only shows partial information.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.