查询sqlserver数据库Schema
摘要:
SELECT TableName=CASE WHEN C.column_id=1 THEN O.name ELSE N'' END, TableDesc=ISNULL(CASE WHEN C.column_id=1 THEN PTB.[value] END,N''), Column_id=C.column_id, ColumnName=C.name, PrimaryKey=ISNULL(IDX.PrimaryKey,N''), [IDENTITY]=CASE WHEN C.is_identity=1 THEN N'√'ELSE N 阅读全文
posted @ 2011-09-08 13:32 RockyLOMO 阅读(3589) 评论(0) 推荐(2) 编辑