Jim Lawrence
accessd at shaw.ca
Thu Jan 12 12:25:28 CST 2006
Susan... and the answer is?? Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: January 12, 2006 8:51 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL Server Express question on informationschemaviews Nevermind... ;) Thanks anyway. Susan H. -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Thursday, January 12, 2006 11:42 AM To: SQL Server List Subject: [dba-SQLServer] SQL Server Express question on information schemaviews 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.17/226 - Release Date: 1/10/2006 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com