Home / Tag Archives: sql-table

Tag Archives: sql-table

Union , Intersect and Except Set Operators

operator

Set Operators : Definition : Set operators are useful in performing the mathematical operations on the data present in the table. There must be at least two select statement so that the operations can be performed on the data by comparing the data from each select statement. Rules to be ...

Read More »

How to Modify table information in SQL database?

Modify Table

Modify Table Structure: We can modify table structure by adding/altering the table using following commands. Add Columns: While adding columns constraints can be applied to the columns. If tables contains data then it won’t be possible to apply “Not Null” & “Primary Key” constraint on the column. Syntax is : ...

Read More »