Data Dictionary Queries for SQL Server & Oracle

For SQL Server –Finding all details of Primary Key constraint select * from sysobjects where xtype=’PK’ –Finding all details of Foreign Key constraint select * from sysobjects where xtype=’F’ –Finding all User-Defined objects (tables, etc) select * from sysobjects where xtype=’U’ –Finding all System objects select * from sysobjects where xtype=’S’ –Finding all user names [...]