7 дек. 2011 г. · Basically I want to get the table names, and the field names for each table from the current database that is connected, nothing else. Is this possible?

7 сент. 2011 г. · I want to know, how can I retrieve Sql-Database schema informations such as Tables, Columns and Their relation between Tables and etc.

23 авг. 2009 г. · The INFORMATION_SCHEMA schema is a good place to start: SELECT * FROM INFORMATION_SCHEMA.TABLES SELECT * FROM INFORMATION_SCHEMA.VIEWS.

2 окт. 2011 г. · Short answer: connect to the default database with psql, and list all databases with '\l' Then, connect to you database of interest, and list tables with '\dt'

24 февр. 2009 г. · If you want to see the entire database structure in one go, type \d * in the psql console. That gives schema of all tables in that database.

22 июн. 2010 г. · I'm looking for a lightweight, open source, more or less cross-database Java library that would allow me to read off metainformation on columns, tables and ...

12 авг. 2009 г. · I am working on a SQL Server 2008 Db that has many tables in it (around 200). Many of these tables contain a field by the name "CreatedDate".

18 дек. 2011 г. · Use the GetSchema method of the SqlConnection class: DataTable t = _conn.GetSchema("Tables"); For more info read the MSDN article Retrieving Database Schema ...

30 сент. 2009 г. · The SHOW CREATE TABLE statement can be used to retrieve the CREATE TABLE statement to reproduce this table. For example: SHOW CREATE TABLE ...

19 июн. 2012 г. · You can use MySQL workbench to reverse engineer the whole database or multiple databases to visualize them for starters.