View creation from other database from SQL for Ax database

To create view  from other database from SQL for Ax database you can get hint by below  script.

 SET QUOTED_IDENTIFIER ON  
 GO  
 Create VIEW [dbo].[TestCustomer]  
 AS  
  SELECT [CUSTGROUP]  
    ,[ACCOUNTNUM]  
   FROM MicrosoftDynamicsAX.dbo.CUSTTABLE  
      group by [CUSTGROUP]  
    ,[ACCOUNTNUM]  
      ;  
 GO  

Source database is MicrosoftDynamicsAX and destination is testDb in this clip.

Just see clip to create view from custtable to other database new view ..

Just need to execute script in query editor of SQL.

Same way you can include more columns by alter alter

THANKS FOR YOUR PATIENT ON WATCHING CLIP.YOU CAN SUBSCRIBE ON MY YOUTUBE CHANNEL TO GET FUTURE UPDATE TO IMPROVE YOUR KNOWLEDGE.



GROUP BY IS REQUIRED TO MAKE VIEW  READ ONLY. SO ITS IMPORTANT.