在命令中 desc employee 就可以看到字段名与数据类型了.如果要查约束的话
select TABLE_NAME,CONSTRAINT_NAME,SEARCH_CONDITION,STATUS
from user_constraints WHERE TABLE_name=upper('&TABLE_Name');
select TABLE_NAME,CONSTRAINT_NAME,SEARCH_CONDITION,STATUS
from user_constraints WHERE TABLE_name=upper('&TABLE_Name');
user_constraints
user_cons_columns
如果要查主键的话,SQL语句该怎么写啊?
select constraint_name from user_constraints where constraint_type='P';desc ...不是SQL语句!是sqlplus特有的命令。