Jagan Mohan Reddy Rajidi
- Sep 25, 2022
- 1 min read

SQL query to display all columns with datatypes for a given Table name

Below query displays all the columns with data types for the given SQL table name. Replace the TableName in below query with your table name.

select c.name[Column Name], case when t.name IN ('char', 'varchar', 'nchar', 'nvarchar') then t.name + ' (' + convert(nvarchar(10),c.max_length ) + ')' when t.name IN ('decimal','numeric') then t.name + ' (' + convert( nvarchar(10),c.precision ) + ', ' + convert( nvarchar(10),c.scale ) + ')' else t.name end [Data Type], case c.is_nullable when 1 then 'Yes' else 'No' end [Allow Nulls] from sys.columns c inner join sys.types t on c.system_type_id=t.system_type_id where object_name(c.object_id)='TableName' order by c.column_id

Recent Posts

See All

SQL Server performance tip - Do not use NOT IN clause in Subquery use LEFT OUTER JOIN instead

Do not use NOT IN clause in sub query, instead of this use LEFT OUTER JOIN shown in below example query. This will reduce the execution time and improves the performance. To know more details with exa

SQL server query to search object name in database

When you create any new object(table, stored procedure, view,...etc.) in database then same object name will be stored in system table Sysobjects. Following query returns all the object names along wi

SQL query to search a column name in all tables

Sometimes you get a scenario where you know the column name but don't remember which table it belongs to. Following query will search for a given column name in database schema and returns all objects

SQL Articles with examples

SQL query to display all columns with datatypes for a given Table name

Recent Posts