12th Lecture

12th Lecture

Error -'Invalid Object Name' means Table doesn't exists.

-'String or binary data would be truncated' means some field is provided with more memory as prescrived for the field

to delette any data from a tabe use command

delete from "table name" where "condition".

to add a new coloumn in a pre existing table

alter table "table name" add "coloumn name u want to add" "type".

to delete a particular row from table

delete from "table name" where "condition".

to delete a column from a table

alter table "table name" drop column "column name".