Back
Theme:

Search a field/column on database


How can I search and find a field/column in the database?

Date: Thursday, April 20, 2023
1 answers | 142 view(s)
by Mauricio Junior

Answers

Try to use this

SELECT COLUMN_NAME AS 'ColumnName' ,TABLE_NAME AS 'TableName'FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%your_field_name%'

Thursday, April 20, 2023

Mauricio Junior


Learn database step by step in practice