Duplicate Column Names in databse

Question

How to get all duplicate column names of all tables in a database in sql server ?

Bhuvanesh Mohankumar · Answer

SELECT table_name, Column_name FROM Information_Schema.Columns GROUP BY Column_name having Count (Column_Name) > 1

Sreekanth Reddy · Answer

@ Bhuvanesh Mohankumar Executed as "select table_name,Column_name from Information_Schema.Columns having Count(Column_Name)>1 " Generated error as : "Column 'Information_Schema.Columns.TABLE_NAME' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." Seems need to provide group by clause... can you please frame it correct.

Bhuvanesh Mohankumar · Answer

select table_name,Column_name from Information_Schema.Columns having Count (Column_Name)>1 Please try this.

Sreekanth Reddy · Answer

@ Bhuvanesh Mohankumar providing the following Error : "An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference."

Bhuvanesh Mohankumar · Answer

select table_name,Column_name from Information_Schema.Columns select table_name,Column_name from Information_Schema.Columns where Count (Column_Name)>1 Mark as answer, if helpful.

Duplicate Column Names in databse

Answers (5)