Francisco H Tapia
my.lists at verizon.net
Wed Mar 12 16:41:30 CST 2003
is this the right syntax?, or should I use the EXEC before it? sp_fkeys @fktable_name = 'tbl_ccStatus' Simple but I still like my script better as I don't have to give it an @pktable_name, just a single table name and it goes out and finds all related FK's for it.. -Francisco http://rcm.netfirms.com On Wednesday, March 12, 2003 2:21 PM [GMT-8], Djabarov, Robert <Robert.Djabarov at usaa.com> wrote: : 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 : : : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com