This SQL is very useful.

I want to get the list of all components ,corresponding records,pages,fields, People Code Events in a query or else is there any way to find it out

u can use this query to get the above result
select * from PSPROJECTITEM where projectname='project name';

PSPROJECTITEM record will capture the objects present in the project only.

If you want to get the list of components, pages, rec, fields then you need to refer differernt tables. I am listing that below

SELECT * FROM PSPNLGROUP ; /* All the Components */

SELECT * FROM PSRECDEFN; /*All the records and views*/

SELECT * FROM PSPNLFIELD WHERE PNLNAME = 'H_HR_CHNG_ASGMNT'; /* Covers record and field associated in a page */

Thanks.
Hari.A