I am in the situation of studying the existing sql server database. For this I am need of the list of tables and columns of that database. Is it possible to take the list. I know some way of copying and storing the information of the table by table in to note pad or something and taking the printout. Is there any other method is there. Please help. Thanks.