select upper( as table_name, upper( as column_name,
a.colid, a.length, a.xprec, a.xscale, a.xtype,(CASE WHEN a.xtype=167 then 'varchar'
WHEN a.xtype=175 then 'char'
WHEN a.xtype=61 then 'datetime'
WHEN a.xtype=106 then 'decimal'
END) as col_type
from syscolumns a,
sysobjects b
and b.xtype='U'
and upper( <> 'DTPROPERTIES'
order by,, a.colid

Tags: , ,

One Response to “Extracting Metadata From SQL Server”

  1. Chris Rigsby says:

    Hey Shane, finally catching up. Heard you’ve had a couple of shifts in the past couple of months. Contact me soon?

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>