Page 2 of 2
Posted: Mon Aug 15, 2005 6:51 am
by raghavan20
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?
Posted: Mon Aug 15, 2005 7:14 am
by feyd
I use DESCRIBE for various reasons.. like filtering certain things... Making sure the information comes out the way I want it to..
Posted: Mon Aug 15, 2005 7:28 am
by raghavan20
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.
Posted: Mon Aug 15, 2005 7:33 am
by feyd
I don't use foreign keys.. ever. Reason why: I have to support many databases. Some compromises have been done.