Easy - Table detials

Last Post 17 May 2006 06:51 AM by eramgarden_SQL. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
eramgarden_SQL
New Member
New Member

--
17 May 2006 06:37 AM
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
nosepicker
New Member
New Member

--
17 May 2006 06:47 AM
I think you're talking about sp_help and sp_helpindex.
eramgarden_SQL
New Member
New Member

--
17 May 2006 06:51 AM
that was it , thanks.
You are not authorized to post a reply.

Acceptable Use Policy