Tuesday, 20 January 2015

get data table details in SQl

SELECT COLUMN_NAME 'All_Columns',DATA_TYPE ,character_octet_length  FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Tb_TVShow'
Posted by at No comments:
Subscribe to: Comments (Atom)