SQL Server Tips

Getting Started with ASP.NET MVC - Part 6: ASP.NET MVC and Entity Framework

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.


	Just Learned

Upload Image

Close it

Select File

Learned something today? Share it, or learn from what others have learned today


	Like

Invite Friends

Tips · Submit A Tip · Members (430) · Preferences · Feedback · Most Liked · Most Learned · Most Discussed · Silver Rated

SQL Server - Use Shift+DEL to delete entire line in Query window

Dec 26 2011 8:58AM by Madhivanan

While you are working in Query window, if you want to delete the current row, you have to highlight entire row and press delete key. Another alternate is to use SHIFT+DEL key. The cursor can be at any position and the entire row will be deleted

5 Comments

I am quite surprised to see a lot of people learn this one. It is a standard feature of the Visual Studio IDE (on which SSMS is based upon). In fact, I can confirm that this one is true starting at least Visual Studio 2005 IDE, meaning that this should be available in the SSMS for SQL Server 2005 also.

commented on Dec 28 2011 2:28AM .

Nakul Vachhrajani

6 · 26% · 5941

Yes but not many people aware of it as most of them might not be working in Visual Studio

commented on Dec 28 2011 2:40AM .

Madhivanan

4 · 39% · 8850

I knew this but never used. I usually do HOME followed by SHIFT + DOWN ARROW to select the entire line and then click on DELETE. I know that is a long route (I can do that quite quickly), but gives me a clear idea of what is being deleted.

commented on Dec 28 2011 5:39AM .

Jacob Sebastian

1 · 100% · 22504

Though, i know this before, i am not using it.

I will use "END" key, which will take me to end of the line. Then i will use SHIFT + HOME to select entire line and then click on DELETE

One reason behind is Shift + Delete works only in Visual Studio and SSMS. In Notepad, it won't work..

commented on Dec 28 2011 6:07AM .

Ramireddy

3 · 39% · 8882

Thanks dear. Please also share seo tips in urdu. i want seo tips thanks

commented on Jan 31 2012 11:03PM .

asifmushtaq38

2045 · 0% · 4

Your Comment

Sign Up or Login to post a comment.

"SQL Server - Use Shift+DEL to delete entire line in Query window" rated 5 out of 5 by 27 readers +Madhivanan