How can I show the table structure in SQL Server?

In this post I am going to show how to get Table structure using SQL Query.
select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'
Example:- 
image

How can I show the table structure in SQL Server? How can I show the table structure in SQL Server? Reviewed by Pubudu Dewagama on 9:23:00 PM Rating: 5

No comments: