Getting all tables and fields from the database 
Author Message
 Getting all tables and fields from the database

has anyone written an SQL query that I could run on a database that will
return a resultset of rows that are all the field names from user defined
tables in my database,

I would like something like this...

TableName        FieldName    PrimaryKey
tableA                field1            true
tableA                field2            false
tableA                field3            false
tableB                field1            true
tableB                field2            false

Can anyone offer me any help.

TIA

Martin



Sun, 14 May 2006 11:04:28 GMT
 Getting all tables and fields from the database

Take to look my replay in previous thread

Andrew


Quote:
> has anyone written an SQL query that I could run on a database that will
> return a resultset of rows that are all the field names from user defined
> tables in my database,

> I would like something like this...

> TableName        FieldName    PrimaryKey
> tableA                field1            true
> tableA                field2            false
> tableA                field3            false
> tableB                field1            true
> tableB                field2            false

> Can anyone offer me any help.

> TIA

> Martin



Sun, 14 May 2006 11:11:26 GMT
 Getting all tables and fields from the database
Thanks, I completely missed that thread when I was looking. Does exactly as
required.

Regards

Martin


Quote:
> Take to look my replay in previous thread

> Andrew



> > has anyone written an SQL query that I could run on a database that will
> > return a resultset of rows that are all the field names from user
defined
> > tables in my database,

> > I would like something like this...

> > TableName        FieldName    PrimaryKey
> > tableA                field1            true
> > tableA                field2            false
> > tableA                field3            false
> > tableB                field1            true
> > tableB                field2            false

> > Can anyone offer me any help.

> > TIA

> > Martin



Sun, 14 May 2006 11:39:05 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Getting a list of Tables and fields in an access database

2. getting field & table constraints

3. Getting a list of fields in a table...

4. Problem getting list of fields in table

5. getting field count on an Access table

6. Getting Table Name from Field Properties

7. Select getting table fields or setting variables?

8. newbie - help getting values from fields in tables

9. Getting the source table from a recordset field?

10. getting field data types of a table

11. Getting fields in a table through a query?

12. Getting a Memo field in a table into a TMemo component


 
Powered by phpBB® Forum Software