Which of the following correctly demonstrates how to retrieve stored routine metadata through information_schema?

Which of the following correctly demonstrates how to retrieve stored routine metadata through information_schema?

Which of the following correctly demonstrates how to retrieve stored routine metadata through information_schema?

A.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = ‘city_pop’ AND ROUTINE_SCHEMA = ‘world’

B.
SELECT * FROM INFORMATION_SCHEMA. STORED_ROUTINES WHERE ROUTINE_NAME = ‘city_pop’ AND ROUTINE_SCHEMA = ‘world’

C.
SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE = ‘city_pop’ AND SCHEMA = ‘world’

D.
SELECT * FROM INFORMATION_SCHEMA.STORED_ROUTINES WHERE ROUTINE = ‘city_pop’ AND SCHEMA = ‘world’



Leave a Reply 0

Your email address will not be published. Required fields are marked *