如何读取表的列名

[taishanwcl]

sql如何读取数据表的列明

[-晴天]

全部用户表的列名:

select a.name from syscolumns a inner join sysobjects b on a.id=b.id and b.type='U'

[GoAwayZ]

select a.name from syscolumns a ,sysobjects b 
 where a.id=b.id and b.type='U'

[GoAwayZ]

select a.name from syscolumns a ,sysobjects b 
 where a.id=b.id and b.type='U' and b.name='你的表名'

[lhblxm]

SELECT   
		cast(a1.name as varchar(20))+'.'+cast(a.name as nvarchar(80)) AS tableName,
		 cast(b.Name as nvarchar) AS colName, 
		 cast( isnull(c.Value, b.Name) as nvarchar)AS colChineseName,
		 b.is_nullable ,
		 b.is_computed ,
		 b.max_length ,
		 b.system_type_id ,
		 h.CLTTypeID  as DataType,
		 b.column_id ,
		 cast(g1.name as varchar(20))+'.'+CAST(g.name AS NVARCHAR(80))AS FKTableName,
		 CAST (f.name AS NVARCHAR(80))as FKColName	
		 ,c.      
FROM Sys.tables a 
	join sys.schemas a1 on a.schema_id =a1.schema_id 
	join Sys.Columns b on a.object_id = b.object_id 
	 LEFT JOIN sys.extended_properties c ON a.object_id= c.major_id and b.column_id =c.minor_id 
	 left join sys.foreign_key_columns d on b.column_id =d.parent_column_id and b.object_id =d.parent_object_id 
	 left join sys.columns f on d.referenced_column_id =f.column_id and d.referenced_object_id =f.object_id
	 left join sys.tables g on d.referenced_object_id =g.object_id 
	 left join sys.schemas g1 on g.schema_id =g1.schema_id 
	 join app.SQLType_CLTType h on b.system_type_id =h.SQLTypeID 
--WHERE a.name!='CLT_ColumnInfoA'    
ORDER BY A.name , b.column_id 

列出所用户表的结构