枚举数据库中所有表的列名(转)
摘要：
枚举数据库中所有表的列名SELECTCASE WHEN C.column_id = 1 THEN O.name ELSE N'' END AS TableName,--表名C.column_id AS Column_id,--列序号C.name AS ColumnName,--列表ISNULL(PFD.value, N'') As Value,--列值ISNULL(IDX_1.PrimaryKey, N'') AS PrimaryKey,--主键CASE WHEN C.is_identity = 1 THEN N'√' ELSE 阅读全文
posted @ 2013-04-15 14:03 owlbcc 阅读(252) 评论(0) 推荐(1) 编辑
