SQL Query To Get Table Details

  1. select DATA_TYPE,* from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME ='MyTableName'