objects install order

[padmanabanravikumar]

I have 2 views and one function in my table.

• View1 - depends on some tables
• View2 - depends on Function1
• Function1 - depends on View1

In this case schema installer not working, it throws dependency object not found exception.

[jorgeyanesdiez]

I have not verified the use case above, but I also get an exception when:

• View1 - WITH SCHEMABINDING, so it depends on the underlying table(s)
• Index - CREATE UNIQUE CLUSTERED INDEX FTX_View1, it depends on View1

The index creation is attempted first, so it blows up.
And yes, I'm creating a unique clustered index on a VIEW, because it's the only way i can create multiple full-text indices on a table (for multiple languages), where the underlying table distinguishes languages by a LanguageId column.

The current workaround is to put the index creation in a separate file, which is loaded into the SchemaInstaller AFTER the file with the view.