Susan Harkins
harkinsss at bellsouth.net
Thu Jan 12 10:45:44 CST 2006
I'm sorry, I forgot the link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ ia-iz_4pbn.asp I didn't find this article or the links to each specific view very helpful. Susan H. I can't figure out the syntax for information schema views. Using this article for 2000, I can get information using this syntax: SELECT * FROM db.INFORMATION_SCHEMA.view WHERE TABLE_NAME = tablename Seems to me, that I shouldn't need a WHERE clause to identify the table. Any help on this one?