Re: View or Table

Posted in 1999

Octav Chiriac — Wed, 29 Sep 1999 18:22:29 +0200 — source: Informix-list mailing list archive (1991-1998)

Sure. SELECT tabtype FROM systables WHERE tabname = "yourtablename" If tabtype is 'V' - it's a view. Best Regards, Octav Roman.Smatana@socpoist.sk wrote: > > Hi, > > I am new in Informix , and want tu ask : > > I have a table and I want to know if a table is table or view. :) > I do not know the script that was a table created. > > Is there any method to find out this ? > thanx > > Roman -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com