Hi,
CDC (Change Data Capture) is used to record the changes that takes place in Tables or in Databases. By default CDC will be in disabled mode. We know we can use triggers to notify the changes in the tables, but triggers always degrade the performance of your databases. So in SQL Server 2008 Microsoft had introduced CDC Concept to capture the DML commands in table and databases. Below code checks whether CDC is enabled or not

Check whether CDC enabled for  Databases
Check whether CDC enabled for Tables

SELECT [name], is_cdc_enabled FROM sys.databases      
GO
 
USE DataBaseName
GO
SELECT [name]is_tracked_by_cdc 
FROM sys.tables
GO
 

note:  if  ‘is_tracked_by_cdc’ column is 1 than cdc is enabled else disabled.
note:  if  ‘is_tracked_by_cdc’ column is 1 than cdc is enabled else disabled