sqldatabase

Describe table structure

Which query will give the table structure with column definitions in SQL?

Solution

  • sp_help tablename in sql server -- sp_help [ [ @objname = ] 'name' ]

    desc tablename in oracle -- DESCRIBE { table-Name | view-Name }