How do you get all the tables and columns in your database where the type is like money?
o.name as tableName,
c.name as ColumnName,
t.Name as ColumnType,
o.type as ObjectType,
u.name as SchemaName
from syscolumns c
inner join sysobjects o
inner join sysusers u
on u.uid= o.uid
inner join sys.types t
on t.system_type_id = c.xtype
where t.Name like '%money%'
Posted by my914 on April 12, 2011 in SQL
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of new comments via email.
Blog at WordPress.com.
Entries (RSS) and Comments (RSS)