Comments
Sort by recent activity
Thank you Alex for the response, it clears up the confusion little bit. So does that mean views dependency issues are all covered by building only and if so how can I build views whose scripts has database name reference. They fails in build. Is there any tweak I can do anywhere so that DLM does not see them as an invalid objects. For example if I have a view script CREATE VIEW sample1 AS SELECT * FROM databasename.schemaname.tablename; Then I am getting build error: WARNING: The error 'Invalid object name databasename.schemaname.tablename;' occurred when executing the following SQL: and if I remove the databasename from the above script then it works. Please suggest me some idea as we have more than 500 views script with similar problem. Thank you for your response again. / comments
Thank you Alex for the response, it clears up the confusion little bit. So does that mean views dependency issues are all covered by building only and if so how can I build views whose scripts has ...