Create, update, delete and query Campaigns.
Table Specific Information
Select all campaigns:
SELECT * FROM Campaigns
Retrieve a specific Campaign:
SELECT * FROM Campaigns WHERE Id = '3130'
To create a campaign, you will need to specify at least the Name column.
INSERT INTO [Campaigns] (Name, Description, CampaignCode, Color, Favorite) VALUES ('Test Camp', 'Test Description', 'tst 001', '0000ff', true)
Update operations are not supported for this table.
Campaigns may be deleted by providing the CampaignId of the campaign and issuing a DELETE statement.
DELETE FROM [Campaigns] WHERE Id = '5161'
The Id of the Campaign.
Name of the Campaign.
The Campaign code.
The Campaign color.
True if marked as favorite Campaign.
The exact time when the Campaign was created.
Last time the Campaign was updated.
Description of the Campaign.