Viewing 15 posts - 76 through 90 (of 160 total)
Select NAME from sysindexes where ID = Object_Id('company')
gives
ICX_COMPANY (clustered)
PK_COMPANY (nonclustered)
and about 98 _WA_SYS temp thingies
September 5, 2008 at 8:46 am
yeah the table does have a clustered index on one column and a compound PK on two columns 🙁
September 5, 2008 at 8:19 am
thank you jack .. so why does the column mentioned in the results have no relation to the actual column in the tables clustered index ?
September 5, 2008 at 8:00 am
oh dear god.. do some of you never leave the darkened corners of the server room ?!!
September 5, 2008 at 7:48 am
thank you both .. its starts to make sense 🙂
~si
August 18, 2008 at 5:07 am
Now just guilty of making occasional Metallica'esc noises on my battered ESP EXP. Wish i could still play properly but wifey-to-be wont let the axes in the house.:angry:
say it is...
August 15, 2008 at 3:53 am
I tend to play acoustic guitar (somewhat badly possibly) when time permits .. if its not work/family/photography time that is
edit when my son was first born I wanted...
August 14, 2008 at 2:48 am
Gianluca Sartori (8/7/2008)
August 8, 2008 at 3:00 am
I now have visions of Gail constantly scanning the obituary columns 🙂
~si
August 6, 2008 at 10:52 am
I saw plenty of wii guns this morning .. a hand full of wii lightsabres and a stack of steering wheels.. but no fits !
August 5, 2008 at 4:29 am
cornflakes or weetabix
cold pizza on occasion
always my own body weight in freshly brewed coffee
July 30, 2008 at 9:40 am
a. thank you very much !
b. feel slightly sheepish at having over engineered it beyond belief !
~si
July 21, 2008 at 8:15 am
Wildcat (7/10/2008)
1. check INFORMATION_SCHEMA.TABLE_CONSTRAINTS for those having FK constraints.....2. then, check sysobjects for those w/o FK.....
Hint: using LEFT JOIN.
*********************************
EDIT:
Actually, you can just query sysobjects.:D
right going to give this a go...
July 14, 2008 at 4:39 am
rbarryyoung (7/10/2008)
try this:
select *
from sys.tables t
Where NOT EXISTS( select * from sys.foreign_keys
Where t.object_id IN (Parent_object_id, Referenced_object_id) )
ahh Im using SQL 2000 but shall bear that in mind...
July 14, 2008 at 4:39 am
whats the phrase,,, not desiring something is just as satisfying as not actually owning it
or something similar anyways 🙂
July 14, 2008 at 3:32 am
Viewing 15 posts - 76 through 90 (of 160 total)