Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

return tables that don't have indexes

Status
Not open for further replies.
crystalhelp

crystalhelp

Programmer
Joined
May 13, 2002
Messages
56
Location
CA
I want to return all tables that don't have an index on a particular field. Can I do that? If so, how? Thanks!
 
Sort by date Sort by votes
This seems to work...
select name
from sysobjects
where type = 'u' and
id not in (select id from sysindexes where indid <> 0)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

WomanPro
  • Locked
  • Question Question
Insert into query adds records to unreadable format, how do I change that?
Replies
5
Views
813
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question Question
return unique rows only
Replies
11
Views
926
Brianfree
Brianfree
briangriffin
  • Locked
  • Question Question
Function Returning Rowcounts
Replies
1
Views
434
briangriffin
briangriffin
Niki_S
  • Locked
  • Question Question
Join SQL tables in foxpro
Replies
1
Views
349
pjw001
pjw001
scubafrog79
  • Locked
  • Question Question
Flag record if there two different locations for that record in another table
Replies
3
Views
414
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top