The Schema Information Panel

• 
  Adding a copy script button would be really handy.

  sangha September 04, 2006 21:00

  - 0 +
• 
  Adding another tab displaying fields in tabular form would be useful. The fields can either be sorted alphabetically or displayed in the sequence as in the table.
  
  
  More description(alter table script for adding constraint) for table constraints, relations etc would be useful while selecting fields.

  sangha September 04, 2006 21:10

  - 0 +
• 
  Thanks for the responses. These are good ideas. We'll certainly be adding select/copy functionality to the script popup.
  Cheers,
  Bart

  Bart Read September 05, 2006 07:50

  - 0 +
• 
  I like the idea of an alternate tabular representation.
  
  Some of the stuff displayed gets rather large, though, and hard to see in any meaningful way. I notice first that the extended properties (which I try to use to document tables and columns) get ridiculously wise; some of the other lines, like constraints, are wide as well. Perhaps some kind of wrapping could be allowed in these cases.
  
  What if this display were interactive? Imagine double-clicking on an object name in the information panel, and have that object become selected in the candidate list?
  
  This would allow the user to locate the target not just by scrolling through categorized lists, but by actually navigating through the structure of the database!

  CWuestefeld September 06, 2006 13:01

  - 0 +
• 
  It's just awesome...AWESOME! Making it selectable will make it even better...this is the only improvement I can think of and it seems like you got it covered

  Lumbago September 07, 2006 03:30

  - 0 +
• 
  1) When I have a stored procedure file opened in the SSMS editor, the SQL window for the candidate list does not update itself properly for EXEC when I am typing the SQL out. For example:
  

  EXEC sp_Ad ==> view sp_AddUser
  

  if I backspace and type
  

  EXEC sp_C ==> view is still sp_AddUser
  

  
  The funny thing is that this does not occur when I am in a new Query window. It only seems to happen when I am editing a stored procedure file.
  
  2) The candidate is case-sensitive. If I don't type the proper case, I usually end up with a blank list.

  brian26ny September 08, 2006 15:19

  - 0 +

Add comment

Please sign in to leave a comment.