Comparison of some specific schema objects of oracle and SQL server

Schema objects

Schema of any database is definition of tables, views, indexes, constraints, stored procedures, triggers and other database – specific objects.

So comparison of some specific schema objects of oracle and SQL server is as given below:

 

 

Schema objects comparison:

 

 

Oracle	Microsoft SQL Server
Database	Database
Schema	Database and database owner (DBO)
Tablespace	Database
User	User
Role	Group/Role
Table	Table
Temporary tables	Temporary tables
Cluster	N/A
Column-level check constraint	Column-level check constraint
Column default	Column default
Unique key	Unique key or identity property for a column
Primary key	Primary key
Foreign key	Foreign key
Index	Non-unique index
PL/SQL Procedure	Transact-SQL (T-SQL) stored procedure
PL/SQL Function	T-SQL stored procedure
Packages	N/A
AFTER triggers	Triggers
BEFORE triggers	Complex rules
Triggers for each row	N/A
Synonyms	N/A
Sequences	Identity property for a column
Snapshot	N/A
View	View

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

COMMENTS:-

There are some differences in schema objects in both the databases. In oracle, there are clusters which allow for a different way to store table data. But there is no such other way to store table data in SQL server. Package is a collection of procedures and functions bundled together, but no package concept is there in SQL server. Triggers for each row, synonyms and snapshot are used in oracle which is not found in SQL server.

Advertisement

~ by sikanderjeet on April 23, 2009.