SELECT
name AS column_name,TYPE_NAME(system_type_id) AS column_type,
max_length,is_nullable
FROM sys.columns
WHERE object_id=OBJECT_ID(N'Product')
order by name
或
exec sp_help '表名'
如何用SQL语句查询一个数据表所有字段的类型
最新推荐文章于 2024-08-14 09:08:52 发布