I have created my own DB which included a table named "Tables_Information". In this table i have created 8 columns which includes, Seq No, Module Name, Table Name, Table Desciption, Table Fields, Fields type, primary key as boolean, Foreign key as boolean.
I want to copy all these information from SQL 2000 DB to my local table fields. Any method / procedure to fulfill this requirement???