Djabarov, Robert
Robert.Djabarov at usaa.com
Wed Mar 12 16:21:53 CST 2003
Sp_fkeys is available for 6.5, 7.0, and 2K and works in all three versions. Robert Djabarov Senior SQL Server DBA USAA IT/DBMS ? (210) 913-3148 - phone ? (210) 753-3148 - pager -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Wednesday, March 12, 2003 4:04 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer]Deleting record (Column Reference Constraint) I don't get back any data with this sp....(on SQL7) but I do get data for the script I'm using.. and it works on both 7 and 2k :S -Francisco http://rcm.netfirms.com On Wednesday, March 12, 2003 1:35 PM [GMT-8], Djabarov, Robert <Robert.Djabarov at usaa.com> wrote: : sp_fkeys <table_name> : : Robert Djabarov : Senior SQL Server DBA : USAA IT/DBMS : ? (210) 913-3148 - phone : ? (210) 753-3148 - pager : : -----Original Message----- : From: Francisco H Tapia [mailto:my.lists at verizon.net] : Sent: Wednesday, March 12, 2003 3:18 PM : To: dba-sqlserver at databaseadvisors.com : Subject: Re: [dba-SQLServer]Deleting record (Column Reference : Constraint) : : In QA, I use this script to find constraints on my tables : : USE YOURDBNAMEHERE : Declare @Var as varchar(100) : SET @Var = 'THE_TABLE_YOUR_TRYING_TO_DELETE_FROM_NAME_HERE' : : SELECT constraint_name, : column_name, : Table_Name, : ordinal_position : FROM information_schema.key_column_usage : WHERE constraint_catalog = db_name() : AND (CONSTRAINT_NAME Like '%' + @Var OR CONSTRAINT_NAME Like '%' + : @Var +'%') : AND LEFT(CONSTRAINT_NAME,2) = 'FK' : ORDER BY constraint_name, ordinal_position : : -Francisco : http://rcm.netfirms.com : : On Wednesday, March 12, 2003 12:30 PM [GMT-8], : David Emerson <davide at dalyn.co.nz> wrote: : :: Thanks for your reply. Where do I find the definition reference? :: :: At 12/03/2003, you wrote: ::: The only time I've seen this type of error is when a related record ::: is going to be deleted. What is the defenition reference for ::: tblCustInvoiceMeter_FK00? ::: ::: -Francisco ::: http://rcm.netfirms.com ::: ::: David Emerson wrote: :::: AXP/SQL2K :::: :::: I have a subform which causes an error message when I delete a :::: record from it - :::: :::: DELETE statement conflicted with COLUMN REFERENCE constraint :::: 'tblCustInvoiceMeter_FK00'. :::: :::: BOL doesn't seem to help. :::: :::: There are no related records to the one I am deleting. Can anyone :::: enlighten me on the problem? :::: :::: :::: Regards ::: ::: ::: _______________________________________________ ::: dba-SQLServer mailing list ::: dba-SQLServer at databaseadvisors.com ::: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver ::: http://www.databaseadvisors.com :: :: Regards :: :: David Emerson :: DALYN Software Ltd :: 25b Cunliffe St, Johnsonville :: Wellington, New Zealand :: Ph/Fax (877) 456-1205 :: :: _______________________________________________ :: dba-SQLServer mailing list :: dba-SQLServer at databaseadvisors.com :: http://databaseadvisors.com/mailman/listinfo/dba-sqlserver :: http://www.databaseadvisors.com : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com : : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com