SQLAI.ai

SQL Queries to Export Database Schema for SQL Server, MySQL, PostgreSQL, and Oracle

how-to

Exporting database schema is depends on the database type you are using. The queries export the following information (sample output is shown below):

SchemaTableColumnTypeLengthNullableDefault
publicUseridtextNullNoNull

The following queries show how to export database schema for the most popular databases (if you spot any mistake in the queries, please let us know):

SQL Server

            
SELECT TABLE_SCHEMA AS [Schema], TABLE_NAME AS [Table], COLUMN_NAME AS [Column], DATA_TYPE AS [Type] FROM INFORMATION_SCHEMA.COLUMNS -- AND TABLE_CATALOG='YOUR_TABLE_CATALOG' (if you are using table catalog) WHERE TABLE_SCHEMA = 'YOUR_DATABASE_NAME'

MySQL

            
SELECT TABLE_SCHEMA AS 'Schema', TABLE_NAME AS 'Table', COLUMN_NAME AS 'Column', DATA_TYPE AS 'Type' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "YOUR_DATABASE_NAME"

PostgreSQL

            
SELECT TABLE_SCHEMA AS "Schema", TABLE_NAME AS "Table", COLUMN_NAME AS "Column", DATA_TYPE AS "Type" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'public' -- OR TABLE_SCHEMA = 'YOUR_DATABASE_NAME' (depending on setup)

Oracle

            
SELECT TABLE_SCHEMA AS 'Schema', TABLE_NAME AS 'Table', COLUMN_NAME AS 'Column', DATA_TYPE AS 'Type' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "YOUR_DATABASE_NAME"

Importing it into AI Bot

After exporting your database schema, export it as a CSV file and you can import it into AI Bot (Click the Settings button). After importing it, you can use it as autosuggestion for your AI Bot by typing / (slash) in the query editor.

References