Listing of Tables & Columns

• • Reply

  18 years ago

  by jonorossi

  Jonathon Rossi

  Brisbane, Australia

  Joined 18 years ago

  hello
  

  
  i need to know what (if any) is the sql statement to do the following:
  1. get a list of the tables in a database
  2. get a list of the columns & their Type, isnull, default from a table
  

  
  thanks for any help u can give me, Jono
  

  Report abuse