System tables and 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

System tables and views

Author

Topic

vasantharajan
Starting Member

5 Posts

Posted - 2009-09-09 : 04:56:35

Kindly help me out to get the answers for the below questions in SQL server ...
1)how to find wat are all the objects in the database ???
2)how to find types of objects in the database ???
3)how to find the decription of the each object type or objects ??
4)how to find the users created in the database ??
5)how to find the triggers present in the databasae ???
6)how to find is any job is scheduled in database ???

Thank you

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-09-09 : 05:02:14

have you try to search these in the Books OnLine ?

KH
[spoiler]Time is always against us[/spoiler]

vasantharajan
Starting Member

5 Posts

Posted - 2009-09-09 : 05:35:10

Thank you for your response,
I dono wat is that book any specific book available ??
Actually i am experienced in oracle ,new to SQL server,

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 05:35:15

quote:
Originally posted by vasantharajan

Kindly help me out to get the answers for the below questions in SQL server ...
1)how to find wat are all the objects in the database ???
2)how to find types of objects in the database ???
3)how to find the decription of the each object type or objects ??
4)how to find the users created in the database ??
5)how to find the triggers present in the databasae ???
6)how to find is any job is scheduled in database ???

Thank you

Are you a student?

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 05:36:32

quote:
Originally posted by vasantharajan

Thank you for your response,
I dono wat is that book any specific book available ??
Actually i am experienced in oracle ,new to SQL server,

Read about INFORMATION_SCHEMA views in sql server help file

Madhivanan

Failing to plan is Planning to fail

vasantharajan
Starting Member

5 Posts

Posted - 2009-09-09 : 05:39:19

Hi madhivanan ...
I am new to sql server but have hand full of experience in the oracle,Now i am need of analysing the SQL server database in which i need to study the existing database so first of all i need to know about the objects and objects types available in SQL server

Thank you..

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 05:45:04

quote:
Originally posted by vasantharajan

Hi madhivanan ...
I am new to sql server but have hand full of experience in the oracle,Now i am need of analysing the SQL server database in which i need to study the existing database so first of all i need to know about the objects and objects types available in SQL server

Thank you..

Ok. Read about sysobjects and information_schema views in sql server help file that will answer most of your questions

Madhivanan

Failing to plan is Planning to fail

vasantharajan
Starting Member

5 Posts

Posted - 2009-09-09 : 05:45:06

Hi Madhivanan..
Thank you for ur reply ,I have gone through the INFORMATION_SCHEMA ,
Is it possible to find the triggers,indexes,synonyms through querying the views/tables in the INFORMATION_SCHEMA???

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 05:50:53

Which version of SQL Server are you using?

Madhivanan

Failing to plan is Planning to fail

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-09-09 : 05:50:56

quote:
Originally posted by vasantharajan

Hi Madhivanan..
Thank you for ur reply ,I have gone through the INFORMATION_SCHEMA ,
Is it possible to find the triggers,indexes,synonyms through querying the views/tables in the INFORMATION_SCHEMA???

You can find all the DB Objects in INFORMATION_SCHEMA go through it!

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/

vasantharajan
Starting Member

5 Posts

Posted - 2009-09-09 : 05:59:37

Thank you for your reply ,And i wanna know are there anything analgous to oracle sequence in MS server ???

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 06:10:24

quote:
Originally posted by vasantharajan

Thank you for your reply ,And i wanna know are there anything analgous to oracle sequence in MS server ???

You can make use of the identity column

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources