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 strongm 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
May 13, 2002
56
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
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
231
Chris Miller
Chris Miller
Brianfree
  • Locked
  • Question
return unique rows only
Replies
11
Views
206
Brianfree
Brianfree
briangriffin
  • Locked
  • Question
Function Returning Rowcounts
Replies
1
Views
97
briangriffin
briangriffin
Niki_S
  • Locked
  • Question
Join SQL tables in foxpro
Replies
1
Views
90
pjw001
pjw001
scubafrog79
  • Locked
  • Question
Flag record if there two different locations for that record in another table 1
Replies
3
Views
99
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top