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 |
|
TJ
Posting Yak Master
201 Posts |
 Posted - 2002-05-03 : 12:56:22
|
Is there such a thing as a 'Dictionary' in SQL. A dictionary would list the attributes for the columns (ie: name, length, indexes, etc) for each table?I know that I can get the column names with this code: Select COLUMN_NAME From EFILING.INFORMATION_SCHEMA.Columns Where TABLE_NAME = 'EFILE' but would like the rest of the information as well.Thanks!TeresaEdited by - tj on 05/03/2002 13:12:21 |
|
|
skond
Yak Posting Veteran
55 Posts |
Posted - 2002-05-03 : 13:47:36
|
| select * from information_schema.columns |
 |
|
|
TJ
Posting Yak Master
201 Posts |
Posted - 2002-05-03 : 13:51:41
|
| THANK YOU!!!"Someday I'll know enough to help someone else!" |
|
|
|
|
|
|
Data Dictionary