Quick View Table Structure and Contents

Viewing table Structure & Contents

USE [db_name]

go

declare @tableName as nvarchar(50) = 'test'

declare @SQLstmt as nvarchar(100) = 'SELECT top 10* FROM [dbo].[' + @tableName + ']'

SELECT obj.type_desc,  OBJECT_NAME(col.object_id) as 'table_name', col.column_id, col.name as 'column_name'

, TYPE_NAME(col.user_type_id) as 'DataType_name'

--, col.system_type_id, col.user_type_id

, col.max_length, col.[precision], col.scale, col.collation_name, col.is_nullable, col.is_ansi_padded, col.is_rowguidcol, col.is_identity

FROM sys.objects obj inner join sys.columns col on obj.object_Id=col.object_Id

WHERE obj.Name=@tableName

--AND col.name LIKE '%org%'

ORDER BY col.column_id

EXEC sp_executesql @SQLstmt