SQL Query for Find the Database Restore & Backup History in SQL Server

SQL Query for Find the Database Restore History in SQL Server

declare @DB sysname = 'DatabaseName';

select * from msdb.dbo.restorehistory where destination_database_name = @DB order by restore_history_id desc;