You want to make a report of table attributes. This report consists of a series of queries on data dictionary views in which you specify the table name, and the queries return details about the table. Your goal is to have information on the report that is similar (in content, not format) to the informaiton you see when you look at the Schema Manager's table property sheet in the console. Include as much informaiton as you can match the information you see for the CLASSMATE.WANT_AD table when looking at the General tab of the property shee (table_name, column names, data types, and so on).
Review the data dictionary views and select the views you think would produce the best results. Then write a series of queires that display the columns you want displayed on the report. Use COLUMN commands to adjust the headings and column width so the report is more readable. Make sure the columns are listed in the same order as they appear on the property sheet.
Write the queries to report the details of the WANT_AD table of the CLASSMATE schema. Save teh script in a file.
Please see table.html file for further information...
Attachment:- New Folder (2).zip