Get all the tablename and columnname of a database

Think that database name is dbEmplyee

use dbEmplyee
select table_name,column_name from INFORMATION_SCHEMA.COLUMNS

Hope this helps you

Kumar