Skip to main content

Posts

Showing posts from December, 2018

How To Create a Full Text Indexed View or Schema Binded View

How To Create a Full Text Indexed View or Schema Binded View To create a schema binded view or full text index on a view, we simply have to write a select statement as we do while creating any normal view fetching data from one or more tables. The only thing different we do here is creating a this view with schema binding. Once we created a schema-bound view, we can add clustered or non-clustered indexes to this view. Check below self explanatory example below that creates a full text index to get family details from Father and Son tables.