Top "System-tables" questions

Find all tables containing column with specified name - MS SQL Server

Is it possible to query for table names which contain columns being LIKE '%myName%' ?

sql sql-server tsql system-tables
How to check if a Constraint exists in Sql server?

I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we …

sql-server information-schema system-tables
How to extract Stored Procedure body in Teradata

I'm trying to extract Stored procedure DDL by querying system tables. If I run the following query select * from dbc.…

procedure ddl teradata system-tables
Which permission need to grant to access sys.dba_systems

I am working on the application which works on Oracle. For some kind of logic I need to get the …

database oracle schema grant system-tables
Difference between SYS.ALL_TAB_COLUMNS and SYS.ALL_TAB_COLS in Oracle 12c

What is the difference between the ALL_TAB_COLUMNS and ALL_TAB_COLS system tables in Oracle 12c? In my …

oracle12c database-metadata system-tables
PostgreSQL: find information about user defined types

Where is information about user-defined types stored? Are there some tables which contain information about the fields of a user-defined …

postgresql user-defined-types system-tables