Listing All Column Information of a Table in SQL Server

Hello to everyone,

In this article, I will try to give information about listing all column information of a table in SQL Server.

In SQL Server, in some cases you may want to list all column information of a table.

You can easily do this using the code below.

SELECT OBJECT_SCHEMA_NAME (c.object_id) SchemaName,
       o.Name AS TABLE_NAME,
       c.Name AS Field_Name,
       t.Name AS Data_Type,
       t.max_length AS Length_Size,
       t.precision AS PRECISION
FROM sys.columns c
INNER JOIN sys.objects o ON o.object_id = c.object_id
LEFT JOIN sys.types t ON t.user_type_id = c.user_type_id
WHERE o.type = 'U' -- and o.Name = N'TableName' -- Tablo adını dilerseniz bu kısımda belirtebilirsiniz.
ORDER BY o.Name,
         c.Name

When you run the above code, you will see a result similar to the one below.

Listing All Column Information of a Table in SQL Server

As you can see, all the columns of the table are listed.

Good luck to everyone in business and life.

76 Views

Yavuz Selim Kart

I try to explain what I know in software and database. I am still improving myself by doing research on many programming languages. Apart from these, I am also interested in Graphic Design and Wordpress. I also have knowledge about SEO and Social media management. In short, I am a determined person who likes to work hard.

You may also like...

Don`t copy text!