Question: Is there a way to get System.AssignedTo to display a value or any field containing an user? Unable to get any identity show.
Results:
Azure REST API Powershell ADO Rest API System.AssignedTo does not show a value
Hi DBTech,
To answer your query, In Management Studio, open the Object Explorer.
Go to your database
There's a subnode Views
Find your view
Choose Script view as > Create To > New query window
In Management Studio, open the Object Explorer.
Go to your database
There's a subnode Views
Find your view
Choose Script view as > Create To > New query window
If you want to retrieve the SQL statement that defines the view from T-SQL code, use this:
SELECT
m.definition
FROM sys.views v
INNER JOIN sys.sql_modules m ON m.object_id = v.object_id
WHERE name = 'Example_1'
If the answer is helpful kindly click "Accept Answer" and upvote it. Thanks.
3 people are following this question.
