asked on Finding a the correct field in in many databases
Is there a way to find a certain fieldname with big SQL database with many tables.
For example. Database01 has 50 tables. Microsoft SQL 2016
how would i find a filed called Node if i don't know the location of the table? Since there are 50 tables, it would be very hard to go through each table looking for the filed Node.
any help would be great.
For example. Database01 has 50 tables. Microsoft SQL 2016
how would i find a filed called Node if i don't know the location of the table? Since there are 50 tables, it would be very hard to go through each table looking for the filed Node.
any help would be great.
Microsoft SQL ServerSQL
Last Comment
sirichaiphumirat
give a try to the free Red Gate SQL Search: https://www.red-gate.com/products/sql-development/sql-search/index
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thank you.. worked great.
1. Write a query. For this you can refer
http://www.sqlmatters.com/Articles/Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx
2. Install a tool.
Eg. a. https://www.apexsql.com/sql_tools_search.aspx ,
b. http://sqllocator.com/
Install and it will do a quick search for you.