Sql creating and maintaining table
Description
In this page we are going to discuss the utility of Sql creating and maintaining table.
- Creating simple table
- Table Constraint
- Creating table using constraint to exclude null values
- Creating table to check unique values
- Creating table using unique constraint
- Creating table using primary key constraint
- Creating table using primary key constraint in more columns
- Creating table to validate or checking columns value
- Creating table to check valid input values using in operator
- Creating table using like operator
- Creating table using check constraint with or operator
- Creating table using check constraint with and,or operator
- Creating table using default constraint
- Create table inserting a default values in fields
- Creating table with foreign key constraint
- Creating table using foreign key in column constraint
- Creating table using foreign key without primary key column list
- Creating table using foreign key with primary key column list
- Creating table using foreign key(>1) with primary key column list
- Create table using cascades
- Create table by referring foreign key to own table
- Understanding the ALTER TABLE Statement
- Using ALTER TABLE Statement Add a Column to a Table
- Drop a column from a table
- Change or drop a column's default value
- Add or drop individual column constraints
- ALTER TABLE Statement to Change size and data type of a column
- Add or drop a table's primary key
- Add or drop foreign keys
- Add or drop table check constraints
- ALTER TABLE Statement to Change Primary or Foreign Key
