MS SQL Server Concepts and Programming Question:

What is a database table?

MS SQL Server Interview Question
MS SQL Server Interview Question

Answer:

A table in database is a data object used to store data. Tables have the following features:

* Data is stored in a table with a structure of rows and columns.
* Columns must be pre-defined with names, types and constrains.
* A table object may have other associated data objects like, constrains, triggers, indexes, and statistics.

For example, a table called Address may have columns defined to store different elements of an address like, street number, city, country, postal code, etc.


Previous QuestionNext Question
What are system databases in MS SQL Server?What are DDL (Data Definition Language) statements for tables in MS SQL Server?