Database mail profiles information

USE msdb
GO
SELECT * FROM dbo.sysmail_profile
GO


USE MSDB
GO
SELECT * FROM dbo.sysmail_server---servername
SELECT * FROM dbo.sysmail_log---gives description in detail


---to delete any old and not useful mail profile use
DELETE FROM  dbo.sysmail_profile
WHERE name = 'xyz'