Search / Find a Column / Table in Database ( Oracle / SQL Server / MySql )

Find Column/Table Name

Oracle:

SELECT table_name,Column_name FROM ALL_TAB_COLUMNS
where COLUMN_NAME like 'FISCALPERIODOID%';

SQL Server:

SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE '%EmployeeID%'
ORDER BY schema_name, table_name;

SELECT * FROM information_schema.tables

SELECT * FROM information_schema.columns

MySQL:

SELECT COLUMN_NAME, TABLE_NAME 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE '%test%' 


No comments: