How do I determine the column names for a table?

Post Reply
rgwin
Posts: 5
Joined: Thu Jul 27, 2006 7:19 pm

How do I determine the column names for a table?

Post by rgwin »

I want to use Texis to make a batch update of a whole bunch of webinator profiles, but I'm have a hard time constructing queries because I can't for the life of me figure out what the column names are for the tables I'm trying to update, and I can't find any command in the documentation that would give them to me.

Basically what I'm looking for is something similar to MySQL's "DESCRIBE tablename" statement. Does Texis have such a thing?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

How do I determine the column names for a table?

Post by John »

The simplest method would be "select * from SYSCOLUMNS where TBNAME = 'tablename'"

The Webinator columns are documented in the Webinator documentation reference section.
John Turnbull
Thunderstone Software
rgwin
Posts: 5
Joined: Thu Jul 27, 2006 7:19 pm

How do I determine the column names for a table?

Post by rgwin »

That's what I needed, thanks!
Post Reply