There is no tag that shows tables and there will be not be such tag.

What you might want to look into ; ZnolkWizard.. This is a handy module
which queries for tables in your database and build create/edit/delete
forms. There is also a handy way to specify key-related data. This gets
you half way to build UIs when you have many tables.

Good luck.

Jose Soares wrote:
> 
> There isn't a SQL standard command to show the tables in the database.
> Thus evry database has a different command to do such job.
> For example:
> 
> DBMaker:
>   to show TABLES:  select  *  from SYSTABLE
>   to show COLUMNS: SELECT  COLUMN_NAME,TYPE_NAME,PRECISION  FROM
> SYSCOLUMN  WHERE  TABLE_NAME='<table_name>'
> MySQL:
>   to show TABLES:  SHOW TABLES
>   to show COLUMNS: DESC <table_name>
> PostreSQL:
>   to show TABLES:  select tablename from pg_tables where tablename not
> like 'pg_%'
>   to show COLUMNS: SELECT a.attname, t.typname, CASE WHEN a.attlen > 0
> THEN attlen ELSE a.atttypmod END as length FROM pg_class c, pg_attribute
> a, pg_type t WHERE c.relname = '<table_name>' AND a.attnum > 0 AND
> a.attrelid = c.oid AND a.atttypid = t.oid
> 
> I wrote a couple of ZSQL Methods to emulate a generic ISQL
> to query a database using the SQL language
> which shows the names of every table in the database
> and every column name, type and length of every table.
> If you want I can send you it.
> 
> Josť
> 
> subrahmanyan kalathur wrote:
> 
> > hi,
> >
> > I would like to know the names of the created table in zsql method.
> > Kindly give me the tag for displaying the table names.( if exists.)
> >
> > thanks
> > bye
> > yours,
> >
> > K.H.Subrahmanyan
> >
> > ( [EMAIL PROTECTED] )
> >
> > _______________________________________________
> > Zope maillist  -  [EMAIL PROTECTED]
> > http://lists.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists -
> >  http://lists.zope.org/mailman/listinfo/zope-announce
> >  http://lists.zope.org/mailman/listinfo/zope-dev )

_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to