Wednesday, February 25, 2009

How to retrieve the column Information of table -sql server

select column_name, data_type, character_maximum_length from information_schema.columnswhere table_name = 'myTable'

No comments:

Post a Comment