In SQL server there is inbuilt stored procedure "sp_columns" which returns columns information of specified table name.
Many people uses this traditional way to see column information. Like , In Microsoft SQL Server Management Studio Go to particular tables then open tables in design view mode. This way is very lengthy.
Using this inbuilt SP you can get quick result.
SQL Syntax :
@table_name : Specify table name.
SQL Query :
Note : Give Us your valuable feedback in comments. Give your suggestions in this article so we can update our articles accordingly that.