List Teams

Table Specific Information

Select

The driver uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

• Id supports the '=' operator.
• ProjectId supports the '=' operator.
• ExpandIdentity supports the '=' operator.
• Mine supports the '=' operator.

The rest of the filter is executed client-side in the driver.

For example:

	SELECT * FROM Teams WHERE ProjectId = '66eb7414-f622-4eff-88da-3ad681f19073' AND Id='717f1ce9-ee4f-4009-9622-4d22f46e5af2'
	SELECT * FROM Teams WHERE ExpandIdentity = true

Insert

The following is an example of inserting into a Teams table:

INSERT INTO Teams (ProjectId, Name) VALUES ('b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937', 'Shubham')

Update

The following is an example of updating a Teams table:

UPDATE Teams SET Name = 'cdata2' WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '619e870e-5242-4218-bedd-c52d8c003591'

Delete

The following is an example of deleting data in a Teams table:

DELETE FROM Teams WHERE ProjectId = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937' AND Id = '619e870e-5242-4218-bedd-c52d8c003591'

Columns