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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to know how the index was created?

Status
Not open for further replies.
Oh

Oh

IS-IT--Management
Jun 24, 2002
92
JP
Hi, my problem is in my DB some guy created indexs for tables before. Now I want to know how did them created. How can I get it?

Thanks
 
Sort by date Sort by votes
You could go into Enterprise Manager. Drill down into the tables folder of the desired database, right-mouse click on a desired table and choose "design". Once inside design mode you will have a menu bar option to view/create indexes.

You could also script out the table to a tex file and see the added indexes and keys

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
320
dhookom
dhookom
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
322
dgillz
dgillz
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
326
torquinian
torquinian
Triacona
  • Locked
  • Question
How to broadcast data from a SQL server to an IP an Port 2
Replies
5
Views
240
fisheromacse
fisheromacse
dgillz
  • Locked
  • Question
SQL Server timeouts after updating workstations to Windows 10
Replies
0
Views
321
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top