alternative show create table in ms access 2000

[deckdeck]

to all geniuses out there,

is there an alternative or counterpart SHOW CREATE TABLE statement in MS ACCESS 2000?mysql support this but i think msaccess 2000 doesnt support this kind of sql statement and i need it in my java program so im looking for an alternative or counterpart sql statement in ms access.or is there a sql statement that will perform the same task in ms access?
thanks...
deckdeck

[mnuttall]

you might ask this in the db forum. I don't remember Access having this functionality. It really isn't a full fledged RDMBS.