SQL Server'da Bir Tabloya Ait Kolon İsimlerini Öğrenmek

SELECT name
FROM   syscolumns
WHERE  id = (SELECT id FROM sysobjects WHERE name='TableName')


* How to find out column names of a table in SQL Server

SQL Server'da Bir Tabloya Ait Kolon Veri Tiplerini Öğrenmek

DECLARE @Table_Name NVARCHAR(100)
SET @Table_Name = 'mytablename'


SELECT object_name(c.id)    AS table_name, 
c.name               AS column_name,
t.name              AS data_type
FROM syscolumns AS c 
INNER JOIN systypes   AS t  ON c.xtype = t.xtype
WHERE c.id = object_id( @Table_Name )


* How to find out column data types of a table in SQL Server