SQL Query (User_Views) - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Query (User_Views)

Author

Topic

sureshcisco
Starting Member

3 Posts

Posted - 2011-09-20 : 04:10:00

I have created a view based on a table e (which is a small identifier alternative for the table abc.employee).



select * from abc.employee;
SQL>  select * from e;

FNAME           M LNAME           SSN       BDATE
--------------- - --------------- --------- ---------
ADDRESS                        S     SALARY SUPERSSN  D
------------------------------ - ---------- --------- -
James           E Borg            888665555 10-NOV-37
450 Stone, Houston, TX         M      55000           1

Franklin        T Wong            333445555 08-DEC-55
638 Voss, Houston, TX          M      40000 888665555 5

How can I query the user_views DD view and display view's name and current status?

Appreciate your help...

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-20 : 05:18:46

is this ms sql server? i dont think user_views is in sql server. if not, you may be better off posting in relevant forums. this is ms sql server forum

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-09-23 : 06:09:41

If you use ORACLE post at www.orafaq.com

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources