<div>
This would help you fetch table names with more than 230 columns.<br />
<br />
SELECT table_name<br />
FROM information_schema.columns<wbr /><br />
GROUP BY table_name<br />
HAVING count(*) &gt;&nbsp;230<br />
<br />
Kindly explain me what you meant by explicit used..
</div>


This would help you fetch table names with more than 230 columns.

SELECT table_name
FROM information_schema.columns
GROUP BY table_name
HAVING count(*) > 230

Kindly explain me what you meant by explicit used..

<div>
I would like to see which columns are used and which are unused.....
</div>


I would like to see which columns are used and which are unused.....

<div>
If the column is filled with data --&gt; the colum is used<br />
if the column is empty --&gt; the column is unused
</div>


If the column is filled with data --> the colum is used
if the column is empty --> the column is unused

<div>
Then you have to use a procedure to loop through all tables and find what are all the list of columns that are used and unused depending upon whether data is present in that table or not.<br />
<br />
Can you kindly elaborate on your requirement so that I can think of some other possibilities.
</div>


Then you have to use a procedure to loop through all tables and find what are all the list of columns that are used and unused depending upon whether data is present in that table or not.

Can you kindly elaborate on your requirement so that I can think of some other possibilities.

<div>
<div class="content wysiwyg-content">
hi there<br />
I want a SQL statement with which i get all views with more than 230 columns AND which shows me which of these columns are explicit used.<br />
<br />
any help would be appreciated!
</div>
</div>


hi there
I want a SQL statement with which i get all views with more than 230 columns AND which shows me which of these columns are explicit used.

any help would be appreciated!

SQL count used columns

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.