Object explorer sql - Компьютерный журнал

Компьютерный журнал
11 просмотров
Рейтинг статьи
1 звезда2 звезды3 звезды4 звезды5 звезд

Object explorer sql

Using Object Explorer Details and Object Search Feature of SSMS 2008

By: Ashish Kumar Mehta | Updated: 2010-02-04 | Comments (2) | Related: More > SQL Server Management Studio

While looking through the new features and improvements in SQL Server 2008 Management Studio (SSMS) we found a potentially interesting one called Object Explorer Details. Database Developers and Administrators can use Object Explorer Details to get a lot of useful information about the object which they have selected in Object Explorer. In this tip I will give you a detailed explanation of how you can use the Object Explorer Details.


In SQL Server 2008 Management Studio, the Object Explorer Details is a very useful tool when compared to the one which was available in SQL Server 2005. You can use this tool to get detailed information about any object which you have chosen in Object Explorer. You can open up an Object Explorer Details window by either pressing the F7 key or by selecting the «Object Explorer Details» option from the «View« menu as shown in the snippet below.

You can see in the below snippet that when the Database node is selected in object explorer, I get a variety of useful information with respect to all of the databases which are available in this particular instance of SQL Server 2008. The information includes the Database Recovery Model, Compatibility Level, Collation, Owner, Size of Database (MB), Data Space Used (KB), Index Space Used (KB), Space Available (KB) etc. The good thing about this tool is that you can also use this against your SQL Server 2005 instances to see all of this information when you connect to a SQL Server 2005 instance using SQL Server 2008 Management Studio.

By default, when you open up the Object Explorer Details window you can see five different columns with valuable data. However, this tool supports about 36 different columns. Based on your requirement you can choose any or all columns which are useful to you. You can add new columns by right clicking any one of the column headings and then select the column of interest from the drop down list as shown in the snippet below. One nice feature is that you can even sort any of the rows and can move them in any order you prefer.

Overview of Object Search

Object Search is a very interesting feature which is integrated within the Object Explorer Details window. Let’s say if you want to search for all the objects which start or end with a name «Addr«, then you can type in the search criteria in the text box and press enter to display the search results as shown in the snippet below.

If you want to search for an object in all the databases then you need to select the Database Node in the Object Explorer window and then provide the name of the object in the text box which needs to be searched for. Once the search has completed you can right click the object which you want to access and then click the Synchronize option from the popup menu to go directly to the location of the object.

Next Steps
  • Next time you need to do some object level searching or investigation, be sure to consider this tip.
  • SQL Server 2008 Management Studio has a number of new features, be sure to check them out.

object explorer

Script Multiple Objects [Easy]

Have you ever noticed that you can only highlight 1 object in the Object Explorer in SQL Server Management Studio? This usually is enough for most things you do, but if you want to script multiple objects at once… it becomes a pain. Well there is a way to script multiple objects at once, and it’s super easy.

  1. Open the Object Explorer Details screen by selecting View -> Object Explorer Details.
  2. Highlight the folder with the objects that you would like script. A list of all objects in that folder will appear on the right. This works for tables, stored procedures, etc…
  3. Highlight all the objects that you want, right click, and select Create To.

Adding All Columns In A Table To A Query [Easy]

I wanted to share this quick tip with you on how to add a list of all the columns in a table to your query window in SQL Server Management Studio. This is the easiest way I know!

  1. Expand the Object Explorer to show the table that you want to add the columns for.
  2. Select the Columns folder on to your query window.
  3. Drag the whole folder on to your query window and just drop it where you want it. That’s it!
Читать еще:  Браузеры на движке gecko

5 Quick Tips For Using SQL Server Management Studio

1) Script multiple objects by using the Object Explorer Details.

Scripting objects like tables and stored procedures is one great feature of SQL Server Management Studio. But the way to script multiple tables at one time is not very straight forward.

To script multiple objects, first thing you need to do is open the Object Explorer Details window. This is located under the VIEW menu at the top of the screen.

When you click on an object’s folder (Tables, Stored Procedures, Views, etc) in the Object Explorer (located on the left of the screen), the Object Explorer Details window will show all of the available tables. You can now highlight multiple objects… then right click and select the Script As option.

2) Add Line Numbers To The Query Window

Line numbers can be very useful when doing development. By default, SQL Server Management Studio has this turned off. To turn this on:

  1. Select Tools -> Options
  2. In the tree on the left, select Text Editor -> All Languages. Under the Display heading, check the box for Line numbers.

3) How To Refresh The IntelliSense Cache

If you’ve ever added a table or stored procedure, you know that the IntelliSense does not know about it. You can refresh the cache pretty easily. To refresh the IntelliSense cache, just selecting Edit -> IntelliSense -> Refresh Local Cache.

4) Highlight Columns Of Text In Query Window

This trick actually works in Visual Studio also. You can highlight and manipulate text in different rows without having to highlight the entire row. This is a little hard to explain, so I will show you pictures of what I mean.

To do this fancy trick, all you need to do is hold down the ALT key while you click and drag.

So, how is this useful you ask… good question. I use it for 2 different things.

  • First is for aligning the sql statement. If you highlight text you can just hit tab and it will tab the highlighted text in more.
  • The second thing I use it for is copying data. If you only want to pull out a specific set of data, this is super easy.

5) Drag And Drop Objects On To Query Window

If you ever want a fast way to place a table name, column name, or other object in to a query… you can just drag and drop. Just drag the object (table, column, store procedure, etc…) from the object browser and place it where you want it on the query window. It will insert the fully qualified name in to the query with no typing needed.

Object explorer sql


I installed SQL Server 2012 and made sure I clicked the data tools option. I see a link that says SQL Server Data Tools and it does open Visual Studio. However, in Visual Studio there is no place to find a SQL Server Object Explorer. Image below shows my start menu, the section of Visual Studio’s View Menu where it should appear and the Server Explorer Window.


It looks like you don’t actually have the database projects portion of SSDT installed. You can get it for free here: http://msdn.microsoft.com/en-us/data/hh297027

  • Proposed as answer by Janet Yeilding Monday, July 2, 2012 7:40 PM
  • Edited by Janet Yeilding Monday, July 2, 2012 7:42 PM
  • Marked as answer by HogHunter Tuesday, July 3, 2012 12:58 PM

All replies

However, in Visual Studio there is no place to find a SQL Server Object Explorer. Image below shows my

The «Object Explorer» is part of SSMS = «SQL Server Management Studio», that’s the app directly under Data Tools.

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

  • Proposed as answer by Janet Yeilding Monday, July 2, 2012 5:30 PM
  • Unproposed as answer by Janet Yeilding Monday, July 2, 2012 7:39 PM

  • Proposed as answer by Jamie Thomson Member Monday, July 2, 2012 5:57 PM

I am not looking for SSMS, I am looking for the Data Tools. The examples I have found all refer to the new SQL Object Explorer in Visual Studio. The walk through at the Code Project shows this image with it clearly visible on the left side. Several pages say it can be found under the view menu.

Читать еще:  Activex для яндекс браузера

I am not looking for SSMS, I am looking for the Data Tools. The examples I have found all refer to the new SQL Object Explorer in Visual Studio. The walk through at the Code Project shows this image with it clearly visible on the left side. Several pages say it can be found under the view menu.

Check my earlier link (above) to download SQL Server Ibject Explorer.

It might be worth trying to reset your Visual Studio settings:

From the Tools Menu, select «Import and Export Settings», then follow the Wizard to reset all your settings.

You can save your existing settings as part of the process.

That tool fails on install. What follows is the error I got:

Install Error : Microsoft.VisualStudio.ExtensionManager.MissingReferencesException: This extension cannot be installed because the following references are missing:
— SQL Server Data Tools — Database Projects
at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.BeginInstall(IInstallableExtension installableExtension, Boolean perMachine, AsyncOperation asyncOp)
at Microsoft.VisualStudio.ExtensionManager.ExtensionManagerService.InstallWorker(IInstallableExtension extension, Boolean perMachine, AsyncOperation asyncOp)

It looks like you don’t actually have the database projects portion of SSDT installed. You can get it for free here: http://msdn.microsoft.com/en-us/data/hh297027

  • Proposed as answer by Janet Yeilding Monday, July 2, 2012 7:40 PM
  • Edited by Janet Yeilding Monday, July 2, 2012 7:42 PM
  • Marked as answer by HogHunter Tuesday, July 3, 2012 12:58 PM

Thank you that was it exactly! Now I can get down to business and play with the new and exciting data tools. I hope I am not disappointed again like previous attempts on Microsoft’s part to deliver a data tool that is really on par with the rest of their tool set.

I hope that you aren’t disappointed, as well! Please let us know what you think.

I done the following.

tools-> Import and export settings -> Import Selected —- -> general development settings.

the server object explorer appeared when i restarted the application.

I have the same problem with visual studio 2013 i tried to install SSDT and import general settings.

It didn’t works for me.

Do you have any ideas ?

Hi, please go to View -> SQL Server Object Explorer, or if it is not visible there try View -> Other Windows -> SQL Server Object Explorer as this window isn’t shown by default. If you cannot find it check Help -> About Microsoft Visual Studio, and verify that «SQL Server Data Tools» are included in the Installed Products list. Note that the SQL Server tools are included in VS Community, Pro, Premium, Professional, Express for Web, and Express for Windows Desktop.

If there are any problems I would suggest repairing Visual Studio, or trying to get the latest update (Tools -> Extensions and Updates -> Updates -> SQL Server tools. ).

Не удается просмотреть базы данных в Visual Studio SQL Server Object Explorer после удаления предыдущей базы данных

Я использовал, чтобы иметь возможность видеть всех баз данных на сервере SQL объектов Explorer в Visual Studio 2012, так. Я сбросил одну из основных баз данных, с которыми я работал в VS, теперь я больше не вижу ни одной из других баз данных.

Я могу подключиться к серверу (SQL Server 2012), но дерево базы данных пустое.

Снимок экрана :

Как восстановить просмотр баз данных?

2 Ответа

Я публикую ответ через 5 лет, поскольку эта потенциальная ошибка все еще является повторением с VS2019. По-видимому, проблема, похоже, связана с базой данных, выбранной при добавлении сервера.

Чтобы решить эту проблему, оставьте имя базы данных по умолчанию, как показано ниже. Тем временем я буду следить за командой VS.

Ладно, нашел ответ:

Мне нужно было установить базу данных по умолчанию в SQL Server с помощью Management Studio.

Как только я сделал это и подключился к серверу в Visual Studio, базы данных появились в объекте Explorer в Visual studio.

Как установить базу данных по умолчанию: вы просто идете в: безопасность — > выберите свой логин — > Свойства -> выберите базу данных по умолчанию.

Похожие вопросы:

Мое веб-приложение использует базу данных MS SQL Server 2008 R2 Express. Чтобы создать сценарий базы данных в Visual Studio 2010, я могу щелкнуть правой кнопкой мыши на моей базе данных в Server.

Предыстория Вопроса Я создал базу данных в Visual Studio на вкладке Server Explorer. Это нормально, но я хотел бы иметь возможность открыть эту базу данных в SQL Server Management Studio (в данном.

У меня возникли проблемы с открытием структуры модели базы данных в объекте сервера SQL Explorer. Обычно это срабатывает, но только сегодня она вдруг перестала открываться. Он просто зависает на.

Читать еще:  Посмотреть адрес по координатам

Я только что создал новую базу данных сервера SQL в Azure, а затем открыл ее в Visual Studio 2015, используя ссылку на портале Azure. Мне пришлось добавить свой IP в брандмауэр, но в остальном.

Я добавил данные в таблицу, и я хочу удалить или отредактировать ее без создания экрана просмотра. Как я могу просматривать данные в таблице базы данных LightSwitch внутри Visual Studio в режиме.

я хочу разработать расширение Visual Studio. Поэтому мне нужны все базы данных, которые подключены через Visual Studio Sql Server Object Explorer. Я хочу подключиться к некоторым из них во время.

Я начинаю использовать Visual Studio 2012 с интегрированными средствами обработки данных сервера SQL, и хотя я смотрел 2 видео microsoft о начале работы с проектами баз данных SQL, мне все еще.

Использование сервера Explorer в Visual Studio 2010 для просмотра и запроса сервера SQL — есть некоторые хранимые процедуры для базы данных, но я не смог найти способ просмотреть тело хранимой.

Я сотрудничаю над проектом с несколькими другими людьми в Visual Studio 2013. Мы используем Tortoise SVN для совместного использования проекта, чтобы все мы работали над одними и теми же файлами. Я.

Quick Search for SQL
Objects and Table Data in SSMS

Search for SQL Server is a FREE add-in for Microsoft SQL Server Management Studio that allows you to quickly locate SQL objects, data, and text in your databases.

When a database contains lots of objects, finding a required table or recollecting names of your stored routines can be quite a daunting task. With Search for SQL Server, you no longer need to look through the entire SSMS Object Explorer to locate a required column name, or text in a stored procedure. The tool will definitely make your life easier.

  • Find fragments of SQL in tables, views, procedures, and functions for free
  • Use wildcards to substitute any characters in a search string
  • Navigate quickly to the object of search in Object Explorer
  • Search across multiple databases and object types
  • Perform objects and data search in SSMS directly
  • Locate tables data according to search string
  • Sort and filter search results
  • Configure search filter

Text Search

You can search a database object by name, and Search will find all objects containing the search query including the stored routines.

Search for:

  • text
  • numbers
  • dates
  • unique identifiers

The tool will search across both objects’ names and bodies.

Data Search

Search for SQL Server includes the Data Search Mode allowing to locate the table, view, stored procedure, function, trigger, etc. containing the required data and then view this data.

For convenience, the results will be displayed in a grid, where you can check:

  • name of an object
  • schema
  • database
  • object type
  • matches count

Wildcard Search

You can use wildcards to substitute any character in a search string. With wildcards, you can match zero or more characters, a set of characters included or absent in an object name being searched, etc.

Using wildcard search feature you can maximize your search results.

SQL Fragment Search

Using Search for SQL Server, you can find a specified SQL code fragment in tables, views, stored procedures, functions, triggers, etc. For example, searching for a «alter» command will return examples of all code fragments containing the command.

Quick Navigation

This feature allows to quickly locate an object rather than browsing through a list of objects in the Object Explorer. With the tool, you can jump to the found object in Object Explorer in a single click.

Regularly, finding anything in the Object Explorer requires a lot of time and eye strain. Using Search for SQL Server, you can eliminate those and navigate to the found object in a flash.

Customizable Search

Search for SQL Server has two modes: DDL and Data modes. Having chosen the mode, you can then customize your search by setting up search criteria:

  • Match case
  • Match whole word
  • Use wild cards

Multiple Search

You can quickly search numerous object types across multiple databases at the same time. This option also allows simultaneously search across the multiple database object types:

  • tables
  • views
  • functions
  • triggers, etc.

Search for SQL Server helps save time and extend productivity.

Search Results Management

Search for SQL Server allows you to sort search results according to your needs. With the tool you can:

  • sort
  • filter
  • group

the results in a grid for a convenient use.

Ссылка на основную публикацию
ВсеИнструменты 220 Вольт