The information schema is a set of views providing metadata for objects in relational databases: tables, views, columns, stored procedures, accounts etc.
I need to know the column type in PostgreSQL (i.e. varchar(20)). I know that I could probably find this …
postgresql types dynamic-sql information-schemaINFORMATION_SCHEMA.TABLES or INFORMATION_SCHEMA.COLUMNS work for only specified databases. Is it possible to query table metadata for …
sql sql-server information-schemaHow can I check when was the last time (timestamp) that I wrote in the database, irrespectively of the database …
mysql database timestamp database-schema information-schemaI need to determine what privileges are currently granted for some materialized views in my database. The query to do …
postgresql privileges materialized-views information-schemaI have a series of stored procedures that select data from a db. I have a role (cctc_reader) that …
sql-server sql-server-2008 permissions information-schemaProbably an easy question.. I've got a list of tables from INFORMATION_SCHEMA and I want to do queries (select, …
mysql select information-schemaThis is going to sound like a crazy request. The databases that I report from do not have any foreign …
tsql sql-server-2000 constraints information-schemaIn MySQL, the syntax DESCRIBE can show a table's structure, but it cannot be embedded to normal statement; is there …
mysql sql select information-schema describeI have a database named test which has 2 views and 2 tables in schema dbo like this: I want to create …
sql-server dynamic-sql information-schema