Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeffT
Posting Yak Master
111 Posts |
 Posted - 2006-03-17 : 16:15:47
|
| Hi,Can someone point me to where I can find out if an SQL server table has an index ? I was in enterprise manager and brought up properties for any given table but was unable to find the information.Thanks,Jeff |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-17 : 16:25:54
|
| Right-click on table, select "All Tasks - Manage Indexes". |
 |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-17 : 16:26:41
|
| Also, in Design mode, you can click the second icon from the right. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-19 : 02:09:51
|
| "you can click the second icon from the right"Isn't support for Visual Tools fun!Kristen |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-19 : 10:36:58
|
| Or in query analyser use sp_helpindex <tblname>==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-03-20 : 00:57:26
|
quote:
Originally posted by Kristen
"you can click the second icon from the right"Isn't support for Visual Tools fun!Kristen
Whoever said "A picture is worth a thousand words" never saw a Windows icon. I fear that someday we will be asked to describe ourselves on resumes using no more than 256 colors on a bitmap of 16 x 16 pixels. |
|
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-03-20 : 08:58:58
|
| With the handle "blindman" you could just use an all black icon, but what are the rest of us going to do? Fortunately we'll be able to "license" an icon from Microsoft for a "nominal" fee. |
|
|
|
JeffT
Posting Yak Master
111 Posts |
Posted - 2006-03-20 : 09:03:41
|
| Thanks very much to all fro your help !!!Jeff |
|
|
|
|
|
|
Indexes on tables