Microsoft
70-433 · Question #67
You are creating a function that references a table. You need to prevent the table from being dropped. Which option should you use when you create the function?
The correct answer is C. WITH SCHEMABINDING. See the full explanation below for the reasoning.
Question
You are creating a function that references a table. You need to prevent the table from being dropped. Which option should you use when you create the function?
Options
- AWITH ENCRYPTION
- BWITH EXECUTE AS
- CWITH SCHEMABINDING
- DWITH RETURNS NULL ON NULL INPUT
How the community answered
(32 responses)- A3% (1)
- B16% (5)
- C75% (24)
- D6% (2)
Community Discussion
No community discussion yet for this question.