我试过了，对我很有效

exec sp_help TABLE_NAME

有几个方法可以获取一个表的元数据:

EXEC sp_help tablename

将返回几个结果集，描述表、它的列和约束。

INFORMATION_SCHEMA视图将为您提供所需的信息，但不幸的是，您必须手动查询这些视图并连接它们。

只需双击表名并按Alt+F1

你可以使用sp_help 'TableName'

这些答案的问题在于，你忽略了关键信息。 虽然这是有点混乱，这是一个快速的版本，我提出，以确保它包含相同的信息MySQL描述显示。

Select SC.name AS 'Field', ISC.DATA_TYPE AS 'Type', ISC.CHARACTER_MAXIMUM_LENGTH AS 'Length', SC.IS_NULLABLE AS 'Null', I.is_primary_key AS 'Key', SC.is_identity AS 'Identity'
From sys.columns AS SC 
LEFT JOIN sys.index_columns AS IC
ON IC.object_id = OBJECT_ID('dbo.Expenses') AND 
IC.column_id = SC.column_id
LEFT JOIN sys.indexes AS I 
ON I.object_id = OBJECT_ID('dbo.Expenses') AND 
IC.index_id = I.index_id
LEFT JOIN information_schema.columns ISC
ON ISC.TABLE_NAME = 'Expenses'
AND ISC.COLUMN_NAME = SC.name
WHERE SC.object_id = OBJECT_ID('dbo.Expenses')

以防您不想使用stored proc，这里有一个简单的查询版本

select * 
  from information_schema.columns 
 where table_name = 'aspnet_Membership'
 order by ordinal_position