<div>
There are two options for you. QUERY/FREE Tool<br />
1. Write a query. For this you can refer <br />
<a href="http://www.sqlmatters.com/Articles/Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx" rel="ugc">http://www.sqlmatters.com/Articles/Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx</a><br />
2. Install a tool. <br />
Eg. a. <a href="https://www.apexsql.com/sql_tools_search.aspx" rel="ugc">https://www.apexsql.com/sql_tools_search.aspx</a>&nbsp;, <br />
&nbsp; &nbsp; &nbsp; b. <a href="http://sqllocator.com/" rel="ugc">http://sqllocator.com/</a><br />
Install and it will do a quick search for you.
</div>


There are two options for you. QUERY/FREE Tool
1. Write a query. For this you can refer
http://www.sqlmatters.com/Articles/Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx [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 [https://www.apexsql.com/sql_tools_search.aspx] ,
      b. http://sqllocator.com/ [http://sqllocator.com/]
Install and it will do a quick search for you.

<div>
give a try to the free Red Gate SQL Search: <a href="https://www.red-gate.com/products/sql-development/sql-search/index" rel="ugc">https://www.red-gate.com/products/sql-development/sql-search/index</a>
</div>


give a try to the free Red Gate SQL Search: https://www.red-gate.com/products/sql-development/sql-search/index [https://www.red-gate.com/products/sql-development/sql-search/index]

<div>
<div class="content wysiwyg-content">
Is there a way to find a certain fieldname with big SQL database with many tables. <br />
<br />
For example. &nbsp; Database01 &nbsp; &nbsp;has 50 tables. &nbsp; &nbsp; Microsoft SQL 2016<br />
<br />
how would i find a filed called &nbsp;Node if i don't know the location of the table? &nbsp;Since there are 50 tables, it would be very hard to go through each table looking for the filed Node.<br />
<br />
<br />
any help would be great.
</div>
</div>


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.

Finding a the correct field in in many databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.