SELECT ValidationName, Active, EntityDefinition.DeveloperName FROM ValidationRule

Note:
When you use Developer Console, use Tooling API to query.

For more fields, check the below link

https://developer.salesforce.com/docs/atlas.en-us.api_tooling.meta/api_tooling/tooling_api_objects_validationrule.htm