hi

you can use microsoft visio for this purpose

create DSN( datasource name) for ur database

open the visio

click on file--> new-->database-->database diagram metric

then click on database--> reverse engineer..

select microsoft sql server and select...