com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.
加一个collate Chinese_PRC_CI_AS
SELECT
so.name table_name,
sep.value table_comment,
so.create_date create_time,
so.modify_date update_time
FROM
sys.objects AS so
LEFT JOIN sys.extended_properties AS sep ON so.object_id = sep.major_id
WHERE
so.type = 'U'
AND sep.minor_id = 0
AND so.name NOT LIKE 'qrtz_%' AND so.name NOT LIKE 'gen_%'
AND so.name collate Chinese_PRC_CI_AS NOT IN (select table_name from gen_table)