[dba-SQLServer] SQL Server Express question on information schemaviews

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


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
 




More information about the dba-SQLServer mailing list