Link to home
Start Free TrialLog in
Avatar of anumit
anumit

asked on

describe table

Hi,
i want to find primary key, foreign keys , unique and other constraints on a table. describe table does not seem to give much information.
An
Avatar of StillUnAware
StillUnAware
Flag of Lithuania image

I'm not sure it'll work on UDB, but this works on MySQL:

show create table <tablename>;
ASKER CERTIFIED SOLUTION
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial