hi , friend ,
"TAB" is a system view in oracle , definitly you can not find it in DB2 or SQLSERVER . desc is a sql plus command . It's not common for all the other database . But you should be able to find the simular syntax , like
in SQLServer , you can use SP_HELP
"TAB" is a system view in oracle , definitly you can not find it in DB2 or SQLSERVER . desc is a sql plus command . It's not common for all the other database . But you should be able to find the simular syntax , like
in SQLServer , you can use SP_HELP
desc colname
这些不是通用的。
最关键的,是要实践。
sybase的
sp_help
sp_helptext
TAB是ORACLE自己带的表,DESC是ORACLE SQLPLUS中的命令