I had blogged about Different ways to know structure of the tables. One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc.
Consider the following object
sys.objects
Applying Alt+F1 will lead to following error
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.'.
The correct method to use that short cut is to wrap the names in square braces
[sys.objects]
So beware of the usage of shortcuts while using keyboard shortcuts
Tags: t-sql, sql_server, table_structure, sqlserver, tsql, SQL Server, #SQLServer,
This is excellent one!
very helpful. thank you!
Thanks Pinal and Jan Novak for your valuable feedbacks
Excellent one.
I wonder, do you have any technique for linked server objects?
SQLZealot, you can use
EXEC linked_server.db_name.owner_name,sp_help 'table name'
I dont think there is a keyboard shortcut
Never knew it thus far! Thanks Madhivanan