What are the database objects? Explain them in brief

What are the database objects? Explain them in brief.

Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server. Server side objects are objects that reside on the server but not in the database. Typical examples of server side objects include, logins, user defined error messages etc. The database objects are contained in the database project while the server objects are contained in the server project. These objects are defined in a .sql file. Most of these objects are defined in a separate file depending on the scenario. E.g it is necessary to specify columns in the same file where the table is defined
Physical database architecture
The physical database architecture describes how the database and files are organized in a SQL server........
What are pages and Extents?
A page is a unit of data storage in SQL. The size of a page is 8Kb. A page has a header and a body. Different types of pages are:......
What are constraints in SQL Server?
Constraints enforce the data integrity to the database and protect columns of the table from unwanted values......
Post your comment