查询SQLServer详细表结构的SQL脚本

最新推荐文章于 2023-07-12 09:09:13 发布

种子长眠于尘埃

最新推荐文章于 2023-07-12 09:09:13 发布

阅读量317

点赞数

分类专栏： SQL相关文章标签： sqlserver 数据库

本文链接：https://blog.csdn.net/fbw668859/article/details/107761443

版权

SQL相关专栏收录该内容

6 篇文章 0 订阅

订阅专栏

select 
	'#tableName#' as TableName,
	c.name AS Name, 
	t.name AS SqlDbType, 
	c.max_length AS ByteLength, 
	c.precision AS Length, 
	c.scale AS DecimalDigits,
	c.is_nullable AS IsNullable,
	i.name as IndexName,
	c.is_identity as IsIdentity,
	i.is_primary_key as IsPrimaryKey,
	i.is_unique as IsUnique,
	i.type as IndexType,
	i.type_desc as IndexTypeName
from  sys.columns c
left join sys.index_columns ic on c.object_id=ic.object_id and c.column_id=ic.column_id
left join sys.indexes i on ic.object_id=i.object_id and ic.index_id=i.index_id
LEFT JOIN sys.types t ON c.system_type_id = t.system_type_id
where  c.object_id = OBJECT_ID('#tableName#')