Create table
The create table key word is used to crate a table in sql server database .Sql server create table syntax
CREATE TABLE table name
( column name1 data type(size),
column name2 data type(size),
column name3 data type(size),
)
Example
create table person(
p_id int,
firstname varchar(50),
lastname varchar(50),
address varchar(70),
city char(20)
)
Drop table
The drop table key word is used to delete a table in sql server database .
Sql server drop table syntax
Drop table table nameSql server drop table syntax
Example
Drop table employee
No comments:
Post a Comment