Sometimes we need to know the table structure information of a database. We need to know the information like columns name, data type, length etc. There are multiple options to find the information. Some of them are
sp_columns: You can execute sp_columns and get the columns information of the table.
Example: exec sp_columns ‘Table Name’
sp_help: You can execute sp_help and get the all the necessary information of the table.
Example: exec sp_help ‘Table Name’
But there is a simple way to get the information. You just need to write the table name in the query editor select the name and press Alt+F1 and it will bring all the information of the table.