This "SQL to get the table name list in different databases" is reproduced from a Blog from the high hand. Thank you for your summary :)
Quote:
I remember that the university just learned SQL Server and was confused for this issue. Today, I accidentally saw a netizen's article, and I was sorted out.
Oracle
Code: SELECT TABLE_NAME from User_Tables Order by Table_NameMysql
Code: Show TableSMS SQL Server
Code: select name from sysobjects where type = n'u 'order by namedb2 udb
Code: select name from sysibm.systables where type = 't' and create! = 'Sysibm' Order by Name
