Hi all,
what is the difference between the system tables
sys references and sysforeignkeys
Regards,
Selva.
by Selva Balaj » Sat, 01 Feb 2003 16:01:41
what is the difference between the system tables
sys references and sysforeignkeys
Regards,
Selva.
by Dejan Sark » Sat, 01 Feb 2003 17:04:13
Sysforeignkeys is a pseudo-table, a table that does not occupy any space. I
think it is for backward compatibility.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Quote:> Hi all,
> what is the difference between the system tables
> sys references and sysforeignkeys
> Regards,
> Selva.
select *
from sysforeignkeys
where rkeyid = object_id('tablename')
How can I convert the following columns (constid
fkeyid, fkey, rkey keyno , key ids) to table names,
column names etc?
Thanks.
3. DBConnect failing under Win9x
4. delete from sysforeignkeys / orphan constraints
5. width of stripe units with informix 7.31 / Solaris 7
6. create a trigger on sysforeignkeys in SQL Server 7
8. Automatic recreate the sysdepends and sysreferences tables
9. SQL 7.0: DBCC checkcatalog error 2513 mismatch SYSREFERENCES<->SYSCOLUMNS
10. Help - SS7: DBCC checkcatalog reports err 2513 mismatch SYSREFERENCES<->SYSCOLUMNS
11. Microsoft SQL Server, sysreferences - select permission denied
12. Help! Weird row in sysreferences table