|
|
8000XXXX Errors ASP.NET 2.0 Classic ASP 1.0 Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search | ASP FAQ Tutorials :: Databases :: Schema Tutorials :: Schema: How do I show the views in a SQL Server database? Schema: How do I show the views in a SQL Server database?
If you want to view (no pun intended) the definition of an individual view, you can simply say:
To get a big script with all the views, you can say:
Related Articles Schema: How do I list all the indexes in a database? Schema: How do I list the databases on my server? Schema: How do I show all the primary keys in a database? Schema: How do I show all the triggers in a database? Schema: How do I show the columns for a table? Schema: How do I show the description property of a column? Schema: How do I show the parameters for a function or stored procedure? Schema: How do I show the stored procedures in a database? Schema: How do I show the tables in a database? Schema: How do I show the user-defined functions (UDFs) in a database? |