1、mysql表结构导出语句
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLUMN_TYPE,IS_NULLABLE,COLUMN_COMMENT from information_schema.columns where TABLE_SCHEMA=“as_salesman” order by TABLE_NAME,ORDINAL_POSITION
参数为库名称。
2、oracle 表结构导出语句
select a.COLUMN_NAME as 列名, a.DATA_TYPE || ‘(’ || a.DATA_LENGTH || ‘)’ as 类型,
a.NULLABLE as 是否可空,a.DATA_DEFAULT AS 默认值,c.COMMENTS
from sys.user_tab_columns a,user_col_comments c
where a.table_name = ‘T_MERCHANT_BASIC_RECHECK’ and c.table_name = ‘T_MERCHANT_BASIC_RECHECK’
and a.COLUMN_NAME=c.COLUMN_NAME;
参数为表名,注意有两个地方需要改。