【文件属性】:
文件名称:显示表结构-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:08
SQL 基础
显示表结构
*
DESC[RIBE] tablename
用 SQL*Plus的 DESCRIBE 命令来展示表的结构.
*
Displaying Table Structure
In SQL*Plus, you can display the structure of a table using the DESCRIBE command. The result of the command is to see the column names and datatypes as well as whether a column must contain data.
In the syntax:
tablename is the name of any existing table, view, or synonym accessible to the user