Get list of all columns of specific data type from a Table in SQL Server

Question

Here Am Using This Query to SELECT COLUMNNAMEFROM INFORMATIONSCHEMACOLUMNSWHERE TABLENAME  39TableName39But Am getting Total Records insteads of i need Specific Columns

Azim · Accepted Answer

You will get all the rows until you specify some condition like DataType ColumnNamelike thisSELECT COLUMNNAMEFROM INFORMATIONSCHEMACOLUMNSWHERE TABLENAME  39Products39AND DATATYPE  39int39

Get list of all columns of specific data type from a Table in SQL Server

Company

Explore

Follow us

Contact Us