1. I think there's a command i can run from QA to show me details of a table: indexes, columns, keys.
I tried :
DBCC DBtable (mytable)
DBCC Checktable ('mytable')
but that's not it.
2. Also, is there a command to show all the indexes and keys in a DATABASE..for example..list the table, then the index, key, if the index is clustered, non-clustered, etc