describe table

Post Reply
Fippy
Posts: 11
Joined: Fri Feb 09, 2007 7:15 pm

describe table

Post by Fippy »

This may be a very newbie question but I can't find a reference in the Texis docs.
Does Texis support the sql "describe <tablename>" ?

E.g.: tsql -c "describe parserinfo"
Complains about the keyword "describe"

How do I obtain the column definitions of a table in Texis?
Thanks,
Fip.
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

describe table

Post by John »

Describe is not supported, you can select from SYSCOLUMNS where TBNAME = '<tablename>' to get the column definitions.
John Turnbull
Thunderstone Software
Post Reply