Home » Posts taggedSql Server

Find most used column names in database – Sql Server

Find most used column names in database Query: [crayon-5c937ea7f1423018267565/]   Columns Description: ColumnName – column name Tables – number of tables that have particular column name PercentTables – percentage of tables with column with that name   Sample Output of  AdventureWorks2017:
Continue reading




DISCLAIMER:
The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.