2007-07-18

Create Data Dictionary By Query

This is a query that use for generate your simple data
dictionary.



Sample

select distinct syscolumns.name,systypes.name as Type,
syscolumns.length,sysproperties.value

From syscolumns
inner join sysobjects on sysobjects.id=syscolumns.id
left outer join sysproperties on
sysproperties.smallid=syscolumns.colid
and sysproperties.id = syscolumns.id
inner join systypes on
syscolumns.xtype = systypes.xtype
where sysobjects.name='TableName'

3 comments:

Anonymous said...

ทำ data dictionary ง่ายขึ้นเยอะเลย จะลองเอาไปใช้ดูนะคะ จะได้ไม่ต้อง Crt+C แล้วก็ Crt+V ตั้งนานกว่าจะเสร็จ

yanmaneee said...

nike outlet
nike air max 2018
yeezy shoes
kd shoes
kyrie 4
balenciaga sneakers
air max 2018
supreme clothing
supreme
off-white

Deep Cleaning Roseville said...

Hi ggreat reading your blog