SQL Server Data Tools (SSDT) is a toolset which provides an environment for you to carry out all your database design work in SQL Server. It can be used to build to build SQL Server relational databases.
I have this view:
CREATE OR ALTER VIEW dbo.City AS SELECT TOP 10 cn.CityNameID, cn.CityName FROM dbo.CityName AS cn WITH CHECK OPTION GOHow can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')See possible answers