How do I view a SQL script?

Question

Select the View in the Object Explorer, right click, and select Script View as -> Create to -> New Query Editor Window. 5 нояб. 2010 г.

How do I get the view script in SQL Server?

Right click the view, select Script View as , CREATE To , New query editor window .

How do I view a SQL query table?

Then issue one of the following SQL statement:1 Show all tables owned by the current user: SELECT table_name FROM user_tables;2 Show all tables in the current database: SELECT table_name FROM dba_tables;3 Show all tables that are accessible by the current user:

Expert · Answer

Right click the view, select Script View as , CREATE To , New query editor window .

Expert · Answer

Then issue one of the following SQL statement:1 Show all tables owned by the current user: SELECT table_name FROM user_tables;2 Show all tables in the current database: SELECT table_name FROM dba_tables;3 Show all tables that are accessible by the current user:

How do I view a SQL script?

How do I get the view script in SQL Server?

How do I view a SQL query table?

Related Questions