|
|
When there are too many columns referenced in a query, it becomes difficult to track the datatype of each column referenced in that query. In such cases, SSMS 2008 offers a very handy feature using which you can determine the datatype and nullability of a column without going to the Object Explorer.
This feature is called the ‘Quick Info’ feature and if not already enabled on your machine, this feature can be enabled using Edit > Intellisense > Quick Info
Once enabled, you can then hover your mouse over a column in a query to see it’s datatype and nullability as shown below. Here we are viewing the datatype and nullability of the EmployeeID column.
Did you like this post?
|
|
||
|
|
|
|
|
subscribe via rss |
|
subscribe via e-mail |
|
print this post |
|
follow me on twitter |
comments
0 Responses to "How to quickly determine the DataType and Nullability of a Column in a query in SQL Server Management Studio 2008"Post a Comment