MS SQL Server, Getting all tables and fields from the database

Getting all tables and fields from the database

Author	Message
Martin De #1 / 3	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

Andrew Pozoloti #2 / 3	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

Martin De #3 / 3	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

Page 1 of 1

[ 3 post ]