Script to find views which has more than 16 columns for unique index/constraint ...for creation of indexed views

• Agnii

  Ten Centuries

  Points: 1192

  More actions

  October 27, 2015 at 9:32 am

  #306110

  Hi, we are on SQL 2014...we have a bunch of views in a database where we are trying to find the views which have more than 16 columns max for unique index/constraint...this is needed so we can convert them to indexed views...any help is appreciated. Thanks!

• happycat59

  One Orange Chip

  Points: 29384

  More actions

  October 27, 2015 at 9:31 pm

  #1835919

  Have a look at view INFORMATION.TABLES and INFORMATION_SCHEMA.COLUMNS - these should be able to give you what you need.