Environments
Retrieves environments.
Table Specific Information
Select
The 本製品 uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=' operator.
For example:
SELECT * FROM Environments WHERE Id = 11
Insert
The Name, Description, and ProjectId can be inserted.The following is an example of inserting into the Environments table:
INSERT INTO Environments (Name, Description, ProjectId) VALUES ('env2', 'inserted environment', '62d9f6e9-17ef-4cbf-833a-eb713c874df1')
Update
The Name and Description can be updated.The following is an example of updating the Environments table:
UPDATE Environments SET Name='updatedEnv', Description='updated environment' WHERE Id = 11
Delete
The following is an example of deleting from the Environments table:DELETE FROM Environments where Id = 11
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
Id of the environment. | |
ProjectId | String | False |
Id of the project. | |
Name | String | False |
Name of the environment. | |
Description | String | False |
Environment description. | |
CreatedOn | Datetime | True |
The date the build was last changed. | |
LastModifiedOn | Datetime | True |
The date the build was last changed. | |
CreatedById | String | True |
Id of the user who created the environment. | |
CreatedByName | String | True |
Name of the user who created the environment. | |
LastModifiedById | String | True |
Id of the user who last modified the environment. | |
LastModifiedByName | String | True |
Name of the user who last modified the environment. |