SQL Server sp_columns does not return expected result
I was trying to check the data types of each column.
I have tried the code below.
use AdventureWorks2014;
exec sp_columns Person;
However, the result return something like this.
PS: I am using AdventureWorks sample database.
There are 3 options available for the Query Results
Results to Text Ctrl + T
Results to Grid Ctrl + D
Results to File Ctrl + Shift + F
Currently your results are showing in Text mode. Changing it to Grid mode, you need to press Ctrl + D or simply select the option as in the screenshot below:
More over, if you are regularly using the sp_columns to get the column details, you can add it as keyboard shortcut by Tools -> Options -> Environment -> Keyboard -> Query Shortcuts.
In the Options you can place the sp_columns against the not reserved columns. For an example, I placed it against the Ctrl + 3.
So the next time when you type the tablename in the query analyzer and Press Ctrl + D then Ctrl + 3, you will get your expected result.
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?