How do I get view details in SQL?

Question

To get the information of a view, you use the system catalog sys.sql_module and the OBJECT_ID() function: SELECT definition, uses_ansi_nulls, uses_quoted_identifier, is_schema_bound FROM sys.sql_modules WHERE object_id = object_id( 'sales.daily_sales' ); EXEC sp_helptext 'sales.product_catalog' ;

How can I see view details in SQL?

Get view properties by using Object Explorer1In Object Explorer, select the plus sign next to the database that contains the view to which you want to view the properties, and then click the plus sign to expand the Views folder.2Right-click the view of which you want to view the properties and select Properties.

How can I see the code of a view in SQL Server?

Right-click the View, select Design. You will see the designer/table layout, Column chooser, the Select statement and a window for results at the bottom.

Expert · Answer

Get view properties by using Object Explorer1In Object Explorer, select the plus sign next to the database that contains the view to which you want to view the properties, and then click the plus sign to expand the Views folder.2Right-click the view of which you want to view the properties and select Properties.

Expert · Answer

Right-click the View, select Design. You will see the designer/table layout, Column chooser, the Select statement and a window for results at the bottom.

How do I get view details in SQL?

How can I see view details in SQL?

How can I see the code of a view in SQL Server?

Related Questions