Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-09-2024 07:03 AM
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'