Hi All
I have a DB , when i go into Diagrams & create the diagrams I can see
that a couple of tables have referntial integrity ... I want to create
a script ... that would let me knw the no. of tables that do not have
referentail integrity ...
Has some got that kind of script
ThanksHi
Do you mean tables that do not have PK,and FK?
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1153716353.700403.319830@.b28g2000cwb.googlegroups.com...
> Hi All
> I have a DB , when i go into Diagrams & create the diagrams I can see
> that a couple of tables have referntial integrity ... I want to create
> a script ... that would let me knw the no. of tables that do not have
> referentail integrity ...
> Has some got that kind of script
> Thanks
>|||Yess
Uri Dimant wrote:
> Hi
> Do you mean tables that do not have PK,and FK?
>
> "Double_B" <bharatbutani@.gmail.com> wrote in message
> news:1153716353.700403.319830@.b28g2000cwb.googlegroups.com...
> > Hi All
> >
> > I have a DB , when i go into Diagrams & create the diagrams I can see
> > that a couple of tables have referntial integrity ... I want to create
> > a script ... that would let me knw the no. of tables that do not have
> > referentail integrity ...
> >
> > Has some got that kind of script
> >
> > Thanks
> >|||Hi
SELECT
name TableName
FROM
sysobjects
WHERE
type = 'U'
AND ( OBJECTPROPERTY(sysobjects.id , 'IsPrimaryKey' ) = 0 OR
OBJECTPROPERTY(sysobjects.id , 'IsForeignKey' ) = 0 )
"Double_B" <bharatbutani@.gmail.com> wrote in message
news:1154002811.976393.60290@.h48g2000cwc.googlegroups.com...
> Yess
>
>
>
> Uri Dimant wrote:
>> Hi
>> Do you mean tables that do not have PK,and FK?
>>
>> "Double_B" <bharatbutani@.gmail.com> wrote in message
>> news:1153716353.700403.319830@.b28g2000cwb.googlegroups.com...
>> > Hi All
>> >
>> > I have a DB , when i go into Diagrams & create the diagrams I can see
>> > that a couple of tables have referntial integrity ... I want to create
>> > a script ... that would let me knw the no. of tables that do not have
>> > referentail integrity ...
>> >
>> > Has some got that kind of script
>> >
>> > Thanks
>> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment