Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: Listing all columns and datatypes

    Hi All,

    I basically into Oracle DB Administration, we are moving the corporate sybase db's to Oracle. Is there anything system tables that list all columns and their datatypes in the database.

    Thanks,
    Vijay

  2. #2
    Join Date
    Feb 2007
    Location
    Chennai, TN
    Posts
    68
    Syscolumns and Systypes system tables are available in sybase.

    Syscolumns table contains the name of the columns in the database
    Systypes contains the datatype informations in the sybase server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •