Wednesday, February 15, 2012

Get data type of a table in database dynamically

You can get the data types of columns in a given table daynamically using system tables as given below: Assume 'CurrentStatus' is the table name.









The column name and the data type will be diplayed as result.

1 comment: