Any azure sql table altered from Gui, if table has constraints or FKs it throws a cannot covert collation error from KW to sql Latin general 1 (American default install). Upon error ing it leaves the tmp.* table it creates as it cannot finish.
Alter Table
Change DataType of Column from varchar(xx) to nvarchar(xx)
click ok or goto script tab
error happens
50% of the time clicking okay will work
50% of the time, it mentions, it cannot delete tmp.* table due to FKs (I assume toad rebuilds the table as a tmp table then drops the old and renames the tmp.* table or something similar). If this one happens the tmp.* will remain and be visible. at this point manual clean up of this table is required.
See 2 screen shots where 1 shows the column dataType change.
and 2nd shows the error message. Looks like a weird Korean collation? not sure I'd have to look that one up
Thanks Logan. Just to check again - did you mean SQL Server in Azure or SQL Azure Database?
I'm playing around with some settings in SQL Server 2019 in Azure and we'll be discussing it with developers. Right now we've been implementing SQL Server 2019 support so please be patient.
Logan, I can't reproduce it. I had a table with an FK, several columns and I tried it back and forth - convert NVARCHAR to VARCHAR with no errors.
Maybe you could send a DDL of your table? Is it only one specific table or any?