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.