Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-10 : 08:02:32
|
| EJC writes "Hello,How would I query the INFORMATION_SCHEMA views to build a list of form fields, data types, and max lengths?(nvarchar fields are easy, but I'm not sure how to go about handling lookup tables, like states)(example: If I have a table, "Contacts", with foreign key field "StateID" which relates to the "StateID" field of "States" table (which has a primary key of "StateCode"))Thanks for your help,Ed C." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-10 : 08:08:48
|
| sp_fkeys 'Contacts' will show you the referenced table>>How would I query the INFORMATION_SCHEMA views to build a list of form fields, data types, and max lengths?Can you explain more on what you are trying to do?Do you want to generate script?If so, see if this helps youhttp://sqlteam.com/forums/topic.asp?TOPIC_ID=53007MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Using INFORMATION_SCHEMA to auto-generate field list -lookup