The work seems to be simpler, if I use this query.
show create table 'table_name'
But I want to know feyd, is this the command you use to create table structures during backup?
Help: file write
Moderator: General Moderators
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
I was telling you earlier that I dont get information on the foreign keys using describe tables which says there are multiple keys available.
If you are not using 'show create table' then how do you extract foreign key information?
When you say filtering certain things, I would like to know them. When you are free, may be you can give a sample list of them.
If you are not using 'show create table' then how do you extract foreign key information?
When you say filtering certain things, I would like to know them. When you are free, may be you can give a sample list of them.