Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - What Is a Table

By: FYIcenter.com

(Continued from previous topic...)

What is a table?

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.

(Continued on next topic...)

1. What is a table?
2. What are DDL (Data Definition Language) statements for tables?
3. How to create new tables with "CREATE TABLE" statements?
4. How To Get a List of All Tables with "sys.tables" View?
5. How To Get a List of Columns using the "sys.columns" View?
6. How To Get a List of Columns using the "sp_columns" Stored Procedure?
7. How To Get a List of Columns using the "sp_help" Stored Procedure?
8. How To Generate CREATE TABLE Script on an Existing Table?
9. How to create new tables with "SELECT ... INTO" statements?
10. How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD"?
11. How To Delete an Existing Column in a Table with "ALTER TABLE ... DROP COLUMN"?
12. How to rename an existing column with the "sp_rename" stored procedure?
13. How to rename an existing column with SQL Server Management Studio?
14. How to change the data type of an existing column with "ALTER TABLE" statements?
15. How to rename an existing table with the "sp_rename" stored procedure?
16. How To Drop an Existing Table with "DROP TABLE" Statements?