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
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
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
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