Informix等同于mysql的SHOW CREATE TABLE [英] Informix equivalent to mysql's SHOW CREATE TABLE

问题描述

informix中是否有与MySQL的SHOW CREATE TABLE <tablename>等效的东西?我想在Server Studio的SQL Manager中运行它，还想获取有关表列及其类型的信息.这可能吗?我已经找到了systables，syscolumns和信息模式，但是对于select * from...的输出结果并不满意.

Is there any equivalent to MySQL's SHOW CREATE TABLE <tablename> in informix? I would like to run it in the SQL Manager on the Server Studio and would also like to obtain information about a tables columns and their types. Is this possible? I've found the systables, syscolumns and information schema, but wasn't lucky with the results I got with the output of select * from... .

推荐答案

我不知道这样的SQL命令.在命令行中，您可以使用dbschema实用程序:

I don't know such SQL command. From command line you can use dbschema utility:

C:\Informix>dbschema -t abc -d test
DBSCHEMA Schema Utility       INFORMIX-SQL Version 11.50.TC6DE

{ TABLE "informix".abc row size = 4 number of columns = 1 index size = 0 }
create table "informix".abc
  (
    xxx integer
  );

revoke all on "informix".abc from "public" as "informix";

如果您想读取systables，请查看我的转储有关表，列，索引等信息的脚本:

If you want to read systables, then look at my script that dumps info about tables, columns, indexes etc: http://code.activestate.com/recipes/576621-dump-informix-schema-to-text/?in=user-186902 . In its source you will find systables queries you can use.

这篇关于Informix等同于mysql的SHOW CREATE TABLE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！