İliskili tablolar ve foreign key alanlarını öğrenme
İliskili tablolar ve foreign key alanlarını öğrenme:
select object_name(fkeyid) as fkey_table,
col_name(fkeyid,fkey) as columname
, object_name(rkeyid) pkey_table
, col_name(rkeyid,rkey) reference_columnname
from sysforeignkeys
where object_name(fkeyid)='tablom'
select object_name(fkeyid) as fkey_table,
col_name(fkeyid,fkey) as columname
, object_name(rkeyid) pkey_table
, col_name(rkeyid,rkey) reference_columnname
from sysforeignkeys
where object_name(fkeyid)='tablom'
This entry was written by
and posted on
Perşembe, Haziran 12, 2008
and filed under
Bookmark the
permalink
.
Follow any comments here with the
RSS feed for this post
.
Post a comment
(
in a new window
)
