gardener
New Contributor III

Hi, re-creating the view is unfortunately not possible because it is system owned.

CREATE OR REPLACE VIEW testcatalog.information_schema.schemata AS SELECT * FROM system.information_schema.schemata WHERE catalog_name = 'testcatalog'

Results:

[CANNOT_DELETE_SYSTEM_OWNED] System owned table cannot be deleted.

Obviously, there's a workaround to query the underlying schemata table in the system catalog directly instead of the schemata view in the testcatalog:

SELECT * FROM system.information_schema.schemata WHERE catalog_name = 'testcatalog'

 

View solution in original post