ODBC Driver for Azure DevOps

Build 22.0.8479


List Projects

Table Specific Information


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

  • Id supports the '=' operator.
  • State supports the '=' operator.
  • GetDefaultTeamImageUrl supports the '=' operator.
  • IncludeCapabilities supports the '=' operator.
The rest of the filter is executed client-side in the 本製品.

For example:

	SELECT * FROM Projects WHERE State = 'wellFormed'
	SELECT * FROM Projects WHERE GetDefaultTeamImageUrl = false
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf'
	SELECT * FROM Projects WHERE Id = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND IncludeCapabilities = true


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

INSERT INTO Projects (Name, Description, Visibility, CapabilitiesVersionControlType, CapabilitiesProcessTemplateTypeId) VALUES ('TestProject', 'This is a test', 'private', 'Git', '6b724908-ef14-45cf')


The following is an example of updating a Projects table:

UPDATE Projects SET Name = 'System.MSPROJ' WHERE Id = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


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

DELETE FROM Projects WHERE Id = 'b154d8f3-bfd9-4bfb-90ae-2e6c8cda8937'


Name Type References Description
ParentReference String
ProjectSK [KEY] String
ProjectId String
ProjectName String
ProjectVisibility String

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479