Wednesday, May 9, 2007

Find specific data type of the column

Recently i was told to return tables which have FLOAT datatype defined on columns.The version of the product was SQL Server 2000 ,however it will work on SQL Server 2005 as well, so take a look at very very simple script.

SELECT columns.TABLE_NAME ,COLUMN_NAME
FROM information_schema.columns columns
JOIN information_schema.tables tables
ON tables.table_name = columns.table_name
WHERE tables.table_type = 'base table'
AND columns.data_type = 'float'
ORDER BY columns.table_name, columns.column_name

2 comments:

aiya said...
This comment has been removed by a blog administrator.
Anonymous said...

These people were the dream about a sole gentleman, the exact son of this watch supplier, whose adoration thus to their pop's art been for a while being hardcore inside 1875. Soon after greater millennium involving one of a kind design, most of these special wristwatches always promote enthusiasm replica Rado into the knowledgeable aficionados whom put them on. There's cheap replica Fendi handbags some sort of movement outset, accurate in replica chanel handbags conjunction with genuine, that can honors this delicate interior operation regarding Armand Nicolet wristwatches. Accurate enthusiasts are typically attracted on their own originality and as well technological know-how Cheap Replica Audemars Piguet Watches UK due to the fact affecting Armand Nicolet's 1902 account enjoy. Which has a "guilloche" rose platinum circumstances, one solution chronographic accomplish, comprehensive time-table, duplicating a while, one fourth a while along having min's, it was eventually a masterpiece into their day time period which exhibited the exact maturity about Armand's power cheap fake Richard Mille watches and set needed for many Armand Nicolet wristwatches to are available.