InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 21:53:11 GMT20http://www.sqlservercentral.com/Forums/Topic840203-49-1.aspxYou can find that in the sysforeignkeys system table. Here's a query that will list foreign key info for the tables in a database:[code="sql"]select t.name as 'Table', c.name as 'Foreign_Key_Constraint', rt.name as 'Referenced_Table' from (select distinct constid, fkeyid, rkeyid from sysforeignkeys) as FK join sysobjects c on c.id = FK.constid join sysobjects t on t.id = FK.fkeyid join sysobjects rt on rt.id = FK.rkeyidorder by 1,2,3[/code]Thu, 31 Dec 2009 16:47:59 GMTGreg Charleshttp://www.sqlservercentral.com/Forums/Topic840203-49-1.aspxBoth Databases are on the same Server which is SQL 2000. Somehow i have managed to collect almost all data but unable to get foreign keys information.Regards,RazaThu, 31 Dec 2009 03:50:34 GMTrazausmanihttp://www.sqlservercentral.com/Forums/Topic840203-49-1.aspxIs your local database that includes the new table in SQL 2005 or SQL 2000? Since you posted in the Integration Services forum, I could assume that it's in SQL 2005 and recommend that you use the Import Wizard in Management Studio.Wed, 30 Dec 2009 09:11:48 GMTGreg Charleshttp://www.sqlservercentral.com/Forums/Topic840203-49-1.aspxDear Friends,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???Regards,Raza UsmaniSoftware EngineerWed, 30 Dec 2009 00:24:21 GMTrazausmani