Views in sqlserver

Question

i have a scenario I created a view with schemabing? suppose the view will be lost? how can we recover that view?

Raja T · Answer

Hello Jayachandra Please refer below links about Schema Binding and Indexed Views https://www.mssqltips.com/sqlservertip/1610/sql-server-schema-binding-and-indexed-views/ http://www.chatsoft.com/aboutus/articles/schema-bound-views.asp http://sqlstudies.com/2014/08/06/schemabinding-what-why/ https://ask.sqlservercentral.com/questions/2582/what-is-schemabinding.html

Francis · Answer

You should consider to use thirdparty sql tool like the one mentioned in the below url: http://solutioncenter.apexsql.com/how-to-recover-stored-procedures-functions-and-triggers/ i hope In normal cases you can't get it back. Hope this helps!