SQL Server 2005 changes for selecting multiple tables

SQL Server 2005 changes for selecting multiple tables

• jbmeeh

  Thanks....this stip saved me a lot of banging on the keyboard.....
  
  

• miguelangel

  Yeah, this makes no sense. Why did you have to mess with it I want to script multiple tables, and I don't have a Summary tab, and I can't find the option to turn it on. Now what One at a time That's great progress...
  
  

• james100

  hi,

  in my case in object explorer in sql server 2005, the ctrl and shift keys do not work, so i can't select multiple tables.

  Is this a standard feature is there an option to make sure I can use ctrl/shift key to do multiple selections

  Thanks,

  
  

• MReynolds

  Hi,

  Thanks, I indeed found out how to do it in the Summary window, rather than in the object explorer window.

  However, can't help but to comment that this is so illogical, complicated and why I have been working with sql server 2000 for many years. Is this improvement Why you need two different windows to manage the same kind of things, and put limits as to what you can do in each window

  nvm.

  
  

• mkamoski

  I agree that deleting multiple tables from the Summary window is illogical, esp when the Summary window is not visible by default. Also, the online help says nothing about it in "How to: Delete Tables from a Database", which is a greater sin
  
  

• dsm1982

  From the Object Explorer, expand the database you want to work with. Then select Tables. This will list out all tables on Summary tab. Select tables you want to either script or delete just like you did in SQL 2000 EM (control, shift, etc.). Right-click to either script or delete.

  
  
  

• somchai

  Hi,

  You can select multiple tables by the way that Young Joo in the previous post has described from the Summary window and you need not go to the Object Explorer for selecting them.

  Thanks and Regards,

  Rajesh

  
  
• SQL Server 2005 changes for selecting multiple tables