Describe table structure

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

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