系统视图，系统表，系统存储过程的使用
获取数据库中用户表信息1、获取特定库中所有用户表信息selectfromsystablesselectfromsysobjectswheretypeU用户表
第二条语句中当typeS时是系统表
2、获取表的字段信息selectfromsyscolum
swhereobject_idobject_id表名selectfromsyscolum
swhereidOBJECT_ID表名3、获取当前库中表的字段及类型信息（1）select字段名a
ame
类型名b
ame字段长度amax_le
gth参数顺序acolum
_idfromsyscolum
saleftjoi
systypesbo
auser_type_idbuser_type_idwhereobject_idobject_id表名syscolum
s与syscolum
s表用法类似。
获取索引或主键信息1、获取对象及对应的索引的信息select对象名A
ame
对象类型atype索引名B
ame索引类型casebtypewhe
1the
聚集索引
whe
2the
非聚集索引whe
3the
xml索引else空间索引e
d主键否casewhe
bis_primary_key1the
主键elsee
dFROMsysobjectsAJOINsysi
dexesBONAobject_idBobject_idWHEREAtypeUANDB
ameISNOTNULLorderbya
ame2、获取表的主键及对应的字段（1）select表名d
ame主键名a
ame字段名c
amefromsysi
dexesajoi
sysi
dex_colum
sbo
aobject_idbobject_ida
dai
dex_idbi
dex_idjoi
syscolum
sco
aobject_idcobject_ida
dccolum
_idbcolum
_idjoi
sysobjectsdo
dobject_idcobject_idwhereais_primary_key1（2）SELECT表名OBJECT_NAMEbpare
t_obj主键名c
ame字段名a
ame
1
fFROMsyscolum
sasysobjectsbsysi
dexescsysi
dexkeysdWHEREbxtypePKANDbpare
t_objaidANDcidaidANDb
amec
ameANDdidaidANDdi
didci
didANDacoliddcolid（3）select所属架构s
ame
表名t
ame主键名k
ame列名c
ame键列序数ickey_ordi
alfromsyskey_co
strai
tsaskjoi
systablesasto
tobject_idkpare
t_object_idjoi
sysschemasasso
sschema_idtschema_idjoi
sysi
dex_colum
sasico
icobject_idtobject_ida
dici
dex_idku
ique_i
dex_idjoi
syscolum
sasco
cobject_idtobject_ida
dccolum
_idiccolum
_idwherektypepk（4）使用系统存储过程获取指定表的主键信息EXECsp_pkeys表名表名只能是当前数据库下的单独表名不能带上架构名3、查询哪些表创建了主键select表名a
amefromselect
ameobject_idfromsysobjectswheretypeualeftjoi
sysi
dexesbo
aobject_idbobject_ida
dbis_primary_key1whereb
ameis
ot
ull注：查询哪些表没有创建主键，将where条件改成is
ull即可。
查找视图信息1、查看视图属性信息execsp_help视图名2、查看创建视图脚本execsp_helptext视图名3、查看当前数据库所有视图基本信息selectfromsysviewsselectfromsysobjectswheretypeVser