and table_name in ( 'ppl', 'ror' ) group by table_name, index_name order by table_name collate utf8_and table_name in ( 'ppl', 'ror' ) group by table_name, index_name order by tab
我需要将类型VARCHAR(16777216)修改为NUMBER in snowflake。ALTER TABLE TABLE_NAME ALTER SQL set data type NUMBER;返回: COLUMN_NAME编译错误:无法将列COLUMN_NAME从类型VARCHAR(16777216)更改为NUMBER(38,0)
ALTER TABLE varchar ALTER varchar type VARCHAR500;返回: TABLE_NA