Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2024 07:45 PM
Hi,
I don't see SET Schema as keyword in Alter table statement. https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-alter-table.html .
I tried your statement.
alter table ****.table_row_count SET SCHEMA ****.table_row_count
ParseException: no viable alternative at input 'alter table****.table_row_count SET SCHEMA'