Creating Sample Tables Srikanth Technologies Form

Instructions and help about Creating Sample Tables Srikanth Technologies

we use create command to create a new table in the database the statement has three mandatory Parts first is name of the table then we have to specify name of the columns along with their data types we can optionally specify some of the constraints like not null unique primary key foreign key Etc looking at the syntax it has two keywords create and table followed by a table name then inside parenthesis we list all the columns and their data types in this example we create a table named employee with four columns employee ID whose data type is integer and has two constraints not null and primary key then employee name whose data type is varsar and maximum size is 50 characters and then address and salary let's execute the query the success message here indicates that the table has been created