Duplicate Column Names in databse
How to get all duplicate column names of all tables in a database in sql server ?
Loading
5 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
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.
- selecttable_name,Column_namefromInformation_Schema.ColumnshavingCount(Column_Name)>1
Bhuvanesh MohankumarPosted May 17, 2016, 7:33 AM