Microsoft
70-433 · Question #141
You need to identify which tables are referenced by name in a stored procedure that does not use dynamic SQL. Which catalog view should you use?
The correct answer is D. sys.sql_expression_dependencies. See the full explanation below for the reasoning.
Question
You need to identify which tables are referenced by name in a stored procedure that does not use dynamic SQL. Which catalog view should you use?
Options
- Asys.procedures
- BINFORMATION_SCHEMA.TABLES
- CINFORMATION_SCHEMA.ROUTINES
- Dsys.sql_expression_dependencies
How the community answered
(39 responses)- A10% (4)
- B8% (3)
- C3% (1)
- D79% (31)
Community Discussion
No community discussion yet for this question.