While creating tables you can apply constrains/rules to column – SQL constraints are used to specify rules for the data in a table. Constraints are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in the table. If there is any violation […]
Read MoreHow to create table using SQL? To create any thing in database SQL provides you create query or command. To create table in database we need to use Create Table query as follows – create table tablename ( fieldname datatype([size]), fieldname datatype([size]) ….) where field name is name of column from table and data type […]
Read MoreWhat is Database? Database is nothing but the collection of information about a particular topic or data stored in way that it can be manipulated easily. In general we store the database in tabular format. Storing data in tabular format makes it easy to manipulate and use. e.g. Buses Database, Flight Database , Student Database. […]
Read More