List teams (default project)

Returns all teams in the default project from the connection. Use this to discover team names and IDs for use in queries or when creating work items. Columns include Id, Name, ProjectId, ProjectName, Url, and Description.

SELECT * FROM Teams