摘要:
select indexs.Tab_Name as [表名],indexs.Index_Name as [索引名] ,indexs.[Co_Names] as [索引列], Ind_Attribute.is_primary_key as [是否主键],Ind_Attribute.is_unique 阅读全文
摘要:
//查询所有表明 select name from sysobjects where xtype='u' select * from sys.tables //查询数据库中所有的表名及行数 SELECT a.name, b.rows FROM sysobjects AS a INNER JOIN s 阅读全文
摘要:
SELECT 表名 = CASE WHEN a.colorder = 1 THEN d.name ELSE '' END , 字段说明 = ISNULL(g.[value], '') , 字段名 = a.name , 类型 = CASE WHEN b.name IN ( 'varchar', 'nv 阅读全文