1
-- ======================================================
2
3--列出sql server 所有表，字段名，主键，类型，长度，小数位数等信息
4
5--在查询分析器里运行即可,可以生成一个表，导出到excel中
6
7-- ======================================================
8
9select
10
11 (case when a.colorder=1 then d.name else '' end)表名,
12
13 a.colorder 字段序号,
14
15 a.name 字段名,
16
17 (<
-- ======================================================2
3
--列出sql server 所有表，字段名，主键，类型，长度，小数位数等信息4
5
--在查询分析器里运行即可,可以生成一个表，导出到excel中6
7
-- ======================================================8
9
select 10
11
(case when a.colorder=1 then d.name else '' end)表名,12
13
a.colorder 字段序号,14
15
a.name 字段名,16
17
(<
首页
下页
尾页
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
本文关键：一些有用的SQL Server语句和存储过程
