Get column data type

Question

dear friends Is there any sql query that returns the data type of a column. Please help me

Vijaya Kadiyala · Answer

Information_Schema.Columns is perfect to your solution. But are you using Oracle or SQL Server?? Thanks Vijaya Kadiyala Http :// dotnetvj . blogspot . com

Lisa · Answer

SELECT * FROM Information_Schema.Columns WHERE Data_Type = @datatype is a simple way to return the data type of a column ofcourse you can always add more conditions to filter your search. Thanks Lisa

Rajendra Deopura · Answer

Dear Try the following link : http://blog.sqlauthority.com/2007/08/09/sql-server-2005-list-all-the-column-with-specific-data-types/