Question : I am having an issue with scaffolding PostgreSQL DB because npgsql does not handle tables with two index […]
Tag: metadata
Check if two databases have same structure
Question : I have a Postgres database that was developed over time, adding tables and keys when needed. Now I’m […]
ObjID in Page Header
Question : I am reading this article: Inside the Storage Engine: Anatomy of a page. I have a database MyDB, […]
How to extract the structure out of DB2 (Back up Structure)?
Question : Is there a way in db2 to take a backup of the database structure (Metadata) without actual data? […]
PostgreSQL equivalent of SQL Server SQL_VARIANT_PROPERTY
Question : Does PostgreSQL have an equivalent function for determining column metadata? Reference: SQL_VARIANT_PROPERTY pg_typeof() appears to be close, but […]
How to get Page Name given Page ID in Oracle Application Express
Question : Prefix: I have looked all over the net for this answer. Let me prefix the question by describing […]
Best way to store units in database
Question : I have inherited a large (SQLServer) database with hundreds of columns that represent amounts of one thing or […]
Track my own custom metadata on Postgres tables and columns
Question : Is there any way to add my own metadata to tables and columns in Postgres, such as key-value […]
MySQL metadata function to get projected column type in query?
Question : Is it possible to get the field type from a MySQL query, in the same way you can […]
Gathering Read Routing information using SMO is inaccurate in SQL Server 2016
Question : I’ve been playing around with SMO to check out some properties recently, and have come across a problem […]