SQL queries to get table and columns names for MySQL, PosgreSQL and SQL Server
Something that now and then are always needed, the SQL queries to get the list of table names from a database, or the column names for a table. Below are the queries for MySQL, PostgreSQL and Microsoft SQL server. MySQL To get the table list: show tables; To get the...
Read More