Question : I am able to access the text definition of stored procedures, views, triggers and functions from sys.sql_modules. I […]
Where to find the OID of a newly created Schema
Question : I have created a new Schema in my Postgres db. I want to replace an OID in the […]
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 […]
Check another session’s IMPLICIT_TRANSACTIONS setting
Question : In SQL Server, you can find IMPLICIT_TRANSACTIONS value for own session via @@OPTIONS. How to find the IMPLICIT_TRANSACTIONS […]
PostgreSQL – Who or what is the “PUBLIC” role?
Question : I was looking at information_schema.role_table_grants when I saw public in grantee column, then I’ve checked at information_schema.enabled_roles but […]
Cleaning up orphaned metadata in information_schema
Question : OK – so the server (Percona 5.6 in this case) ‘went away’ in the middle of declaring a […]
How do I list or search all the column names in my database?
Question : I want to search for a string in the names of the columns present in a database. I’m […]
Is it a best practice to contrast table and dependent view metadata to target which views to refresh?
Question : We have non-indexed views created on vendor tables. When they change table structure or column definitions we run […]
Postgres metadata: get a list of all MATERIALIZED VIEW columns, with data type, INCLUDING array columns
Question : I need to get metadata about all MATERIALIZED VIEW columns, including their data type. I can do this […]
InnoDB row metadata size (minimum row size)
Question : I’m trying to decide whether to normalize a thing further, and need to know what the smallest a […]