Referential Integrity

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:[vbcol=seagreen]
> 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
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:
>|||SQL Server has a basic data modeler (diagrams) that allows you to create
foreign keys between tables. It is not as nice or powerful as Erwin, but it
gets the job done (and it is free).
If you want to stick with Microsoft products you could try using Visio. I
remember seeing database diagramming capabilities in some of the versions.
I haven't looked at the new Visual Studio offering, but they might have
something in there:
http://msdn.microsoft.com/vstudio/t...ro/default.aspx
Here are a few other tools that I am aware of:
WinSQL
http://synametrics.com/SynametricsWebApp/WinSQL.jsp
SQL Diagrams
http://www.skilledsoftware.com/sqldiagrams.htm
Keith Kratochvil
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:059856C5-B1EE-481D-A301-A93D62E11EAD@.microsoft.com...
> We are currently using Erwin for our Data Modeler, but wanted to know if
> there are any good tools, or better data modelers, to help with our
> project
> of referential integrity. Currently we use triggers to enforce our
> referential integrity, but we would like to move towards using constraints
> to
> enforce our data integrity. Currently using SQL Server 2000.