Can we see the table and primary keys, unique keys

[GoogleCodeExporter]

Why cant we see what is the clustured index what is the fragmentation on 
it and other details of stats are up to date or out of date.

Need more usability to it, its a wonderfull tool love the ctrl+click its 
the best i have seen not even in microsoft sqlserver 2008, wonderfull 
please let us know if there is any new release.

Original issue reported on code.google.com by bhushanv...@gmail.com on 13 Jul 2009 at 4:00

[GoogleCodeExporter]

how i can reproduce this problem?
can you show me difference with other ddl tool?

Original comment by daggett....@gmail.com on 15 Jul 2009 at 7:42

[GoogleCodeExporter]

When you look at the object explorer it has no drill down from table level to 
see 
the foreign keys and primary keys in the table definition,

Could we have this feture.

Original comment by bhushanv...@gmail.com on 27 Jul 2009 at 1:01

[GoogleCodeExporter]

Original comment by daggett....@gmail.com on 10 Aug 2009 at 8:50

• Changed state: Accepted
• Added labels: Priority-Medium, Type-Enhancement

[GoogleCodeExporter]

Right-click table DDL doesn't work for you?  It shows primary key even if it is
clustered, external references (foreign keys), permissions and some other 
important info.

Original comment by juliocro...@gmail.com on 18 Aug 2009 at 7:03

[GoogleCodeExporter]

It also shows indexes and unique constraints

Original comment by juliocro...@gmail.com on 18 Aug 2009 at 7:03

[GoogleCodeExporter]

you are right but i was talking about the user friendly approach to it add one 
more 
branch to the tree for columns in the table. and keys, Indexes, each in 
different 
folder under the object would be ideal just like any other object browser 
supports.

i can also do a sp_help index to get the indexes out.

but its the UI i was behind.

Original comment by bhushanv...@gmail.com on 19 Aug 2009 at 6:23