Junior — Middle
Have you ever extracted a table schema from a database?
sobes.tech AI
Answer from AI
Yes, extracting table schema from a database is a common task in testing and automation.
This is usually done using SQL queries to system tables or database metadata. For example, in PostgreSQL, you can get a list of tables and their columns like this:
SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'public';
In QA, this helps verify the database structure against requirements, automate data integrity tests, and ensure migration correctness.