Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.
Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).
Friends, Is there any sql query which returns the data type of the fields in a table. please help me
Shivanandan C V
select name,column_id,system_type_id,type_name(system_type_id) system_type_name,max_length from sys.columns where object_id=object_id('"Schema".tableName')