/* Get original create statement for table or view */ 

/* Cannot obtain the original "create table" instructions */
/* You can for views                                      */

select table_name, view_definition from information_schema.views 
where table_name = 'v_student_roster';