retrieve foreign keys list
Date: Sat, 21 Jul 2001 21:52:23 GMT
Message-ID: <9gaott$bcv$1_at_serv1.iunet.it>
Hi to all!!
I have an Oracle 8 database.
[Quoted] [Quoted] No, I'm implementing an import operation from an ASP page.
[Quoted] Because there are some relationships between tables when I try to delete
rows before import or I try to insert rows in a table without related rows
in the other table I receive an error.
So I decide to drop all foreign keys from destination database, import data
and then add foreign keys.
[Quoted] [Quoted] It is good, but I don't say how I can retrieve foreign keys list for tables.
[Quoted] [Quoted] In SQL Server 2000 there is a stored procedure called sp_fkeys where passing
[Quoted] [Quoted] table name I have for result a recordset with all foreign keys for specified
table.
[Quoted] [Quoted] Does exist a similar stored procedure, function or SQL statement that is
able to retrieve table's foreign keys?
Remember that I need to use this function from ASP so I need a statement
that I can use from ADO.
Please help me.
Thanks in advance.
Bye
Received on Sat Jul 21 2001 - 23:52:23 CEST