Which two statements provide the definition for a view named view1 in the test database?

Which two statements provide the definition for a view named view1 in the test database?

Which two statements provide the definition for a view named view1 in the test database?

A.
SHOW CREATE VIEW view1 FROM test

B.
SHOW CREATE VIEW test-view1

C.
SELECT VIEW_DEFINITION_SCHEMA.VIEWS
FROM INFORMATION _SCHEMA.VIEWS
WHERE TABLE_NAME=”view1”
AND TABLE_SCHEMA = “test”

D.
SELECT DEFINITION
FROM INFORMATION_SCHEMA.VIEWS
WHERE NAME = “test”

E.
SHOW DEFINITION FOR test.view



Leave a Reply 4

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


Vince

Vince

Correct syntax:
B. SHOW CREATE VIEW test.view1;
C. SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.views WHERE TABLE_NAME=”view1″
AND TABLE_SCHEMA=”test”;

armir01

armir01

B C tested