[dba-SQLServer] SQL Server Express question on information schema views

Susan Harkins harkinsss at bellsouth.net
Thu Jan 12 10:41:32 CST 2006


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?
 
Susan Harkins



More information about the dba-SQLServer mailing list