How to get OptionSet values using SQL?

Obtaining a list of option values for a MS CRM 2011 OptionSet is pretty simple, especially if you plan to do this via the CRM Web service API. However a requirement may arise where you may want to do this using direct SQL against the Organization database.

Example Background

By default on the account entity there are several address fields, and one in particular is the Address Type picklist which is used to categorize the type of address stored for this account. Using this field as an example, the following SQL Query can be used to obtain a list of all options available to that field:

SQL Statement

2. SELECT
3. EV.LogicalName as Entity,
4. ALV.Name as Attribute,
5. LLV.Label,
6. APV.Value
7. FROM LocalizedLabelView as LLV
8.     INNER JOIN AttributePicklistValueView as APV ON LLV.ObjectId = APV.AttributePicklistValueId
9.     INNER JOIN OptionSetView as O ON APV.OptionSetId = O.OptionSetId
10.     INNER JOIN AttributeLogicalView as ALV ON O.OptionSetId = ALV.OptionSetID
11.     INNER JOIN EntityView as EV ON ALV.EntityId = EV.EntityId
12. WHERE
13.     ALV.Name like '%address1_addresstypecode%' AND EV.LogicalName = 'account'
14. ORDER BY EV.LogicalName, ALV.Name, APV.Value

SQL Results

Enjoy :)