SQL Server Table - CREATE, ALTER, DROP With Example
#DecodeITeS
SQL Server Table - CREATE, ALTER, DROP
A Table is a database object which stores data in Row & Column format similar to excel \ spreadsheet. Each column is considered as filed and each row is a unique record for the database. One table supports a maximum of 1024 columns in the table and the maximum number of tables in SQL Server is limited by the maximum number of objects supports in the database (2,147,483,647).
Types of Tables
System Tables:- System tables in SQL Server are used to save system data & configurations. Users cannot update \ modify or drop system tables.
User-Defined Tables:- User-Defined tables in SQL Server are created & used by users to stores user or application-specific data.
Standard Tables:- Standard tables are normal user tables with no special functions or customizations.
Temporary Tables: Temporary Tables are temporary objects and create in TempDB.
Partitioned Tables: In Partitioned tables, data is divided and segregated into multiple filegroups.
Wide Tables: Wide Tables use sparse columns to eliminate NULLs and increase the total value of columns from 1024 to 30,000.
Regards
Rohit Garg