1) How can i have a list of about 100 database table with their column name and datatype into a list which i can use for my query
Some thing like a data diagram that came into effect with 2000

2) My database keeps on growing for each day how do i make only current year transaction (info) in the database and rest somewhere backed up
so each time we make a query we dont have to go through each and every record since past 5 yrs in database to return a query

New bee so explain