Question : Is there any way to get the exact row count of all tables in Postgres in fast way? […]
Tag: metadata
Searching for a Data Dictionary for SQL or Oracle
Question : I am looking for metadata specifications (data dictionary) for SQL Server and Oracle databases. By metadata map, I […]
Check if two tables have the same structure (are compatible)
Question : I was wondering if there is an established way to test if two PostgreSQL tables/relations have the same […]
Deny user to see any database through DB_NAME()
Question : I’ve already prevented user to see any database (deny view any database to [login]) and it works. But […]
How to create relationship metadata between tables without a foreign key check?
Question : I use database metadata (primary keys, foreign keys, table names, etc), to generate code and some very complex […]
What significance does an index_id < 256000 have?
Question : In a certain tutorial I read the author is filtering sys.indexes based on the predicate index_id < 256000. […]
How to determine the fully qualified tablenames of aliased tables, when a specifically named column is used in a stored procedure in SQL Server?
Question : suppose StoredProcedure1 (SP1) contains the following SELECT A.COL1 ,A.COL2 ,B.COL2 ,C.COL5 FROM MYBIGTABLE A INNER JOIN MYSMALLTABLE B […]
PostgreSQL – Date added row metadata
Question : Is there a means of differentiating rows added after a certain date without explicitly storing that information as […]
How to GRANT or DENY access to an object based on metadata for that object in SQL Server?
Question : We are in the process of reviewing our database permissions among various applications and business groups on SQL […]
Tagging PostgreSQL database
Question : Is it possible to “tag” a PostgreSQL database with meta-data? Here is my intended use case: I have […]