Forum Discussion
Viewing/Editing of SQL Views
Hi NotebookEnjoyer,
You can use Download SQL database project to export a compressed copy of your entire Warehouse or Lakehouse and access all view definitions.
In addition to the solution suggested by rizalard0684, another quick UI-based option is to use Query Activity (see screenshot). It shows all recently executed queries along with imp details like duration, run count, and success/failure status.
For scalability, I would recommend creating views via Stored Procedures (editing views would be much simpler, this way). Think of them as warehouse-specific pipelines. You can even manage multiple view definitions within a single stored procedure.
In short NotebookEnjoyer you are correct.
In Fabric Warehouse, there is no UI option to view or edit a SQL view’s definition directly from the object.
You can see the SQL definition only via T‑SQL (for example using sys.sql_modules or sp_helptext), and you can edit it only by running a new CREATE OR ALTER VIEW statement in the SQL editor.
There is no setting or permission you’re missing, I believe it’s a current platform limitation.
If this helped, please consider giving a Kudos or Mark my post as a solution!
This is the easiest way to do it, it is very much like the sql function alter view, here it is just combined.