The information schema is a set of views providing metadata for objects in relational databases: tables, views, columns, stored procedures, accounts etc.
I have 2-3 different column names that I want to look up in the entire DB and list out all …
mysql information-schemaI have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we …
sql-server information-schema system-tablesWhat is the best way to list all of the tables within PostgreSQL's information_schema? To clarify: I am working …
sql postgresql information-schemaPostgres 8.4 and greater databases contain common tables in public schema and company specific tables in company schema. company schema names …
sql database postgresql information-schema search-pathI'm trying to test if a given default constraint exists. I don't want to use the sysobjects table, but the …
sql sql-server tsql information-schemaAlright, so here is the scenario I performed a full backup on my mysql server today. Now when I try …
sql phpmyadmin information-schemaI had an assignment for each table to count nullable columns. Easy: SELECT table_name, count(*) FROM INFORMATION_SCHEMA.COLUMNS …
sql postgresql information-schemaIs there a simple alternative in PostgreSQL to this statement produced in Oracle? select table_name from user_tab_columns …
postgresql information-schemaI need to get column names and their tables in a SQLite database. What I need is a resultset with 2 …
sqlite information-schemaI'm looking for the most portable method to check for existence of a trigger in MS SQL Server. It needs …
sql-server triggers information-schema