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 |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-07-17 : 11:26:13
|
| The dB is remote so I need a line of sql or system stored procedure call which will list all defaults, indexes, constraints either db wide or for a specific table through a query analyser. This is because I have built a dB which is live and I let my indexing slip, so want to compare the live dB against my local dev dB and amend where necessary.Thanks in advance. |
|
|
|
|
|
How do I check an Index on a table?