0
You drop the table and the row is deleted along with it.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
How you delete duplicate row of table in SQL?
This can be different depending on the SQL server involved. Please specify the Database being used (ie, mysql, postgresql, oracle, ms SQL Server) I am using SQL 2005 express, what is the command, i can only get... delete... and what else? lets say i want to delete a duplicate row that is row 2.
What is the means drop command in sql?
The DROP command allows you to delete things such as tables or indexes.
What is the purpose of the AS command in SQL?
If you are in search of learning the purpose of the AS command in SQL, there are a few resources that are available to you. One resource that can explain the purpose of the AS command in SQL is Wikipedia.
What does the replace command perform in SQL?
The replace command function in SQL preforms comparisons on the collation of an input or inputs. It also replaces the text in a string of the SQL server.
How do you take delayed backup in SQL Server?
go to sql command prompt.
What does a SQL Delete statement allow?
An SQL Delete statement is a code used for programming. It allows you to delete a single record or multiple records from a graph or table. These codes can be very useful.
Which statement should you use to delete all rows in a table without having the action logged in SQL?
Drop table statement
How data can be edited or deleted from database via php?
if you know SQL language, you can run any command by using PHP's mysql_query() function.
Can you use SQL to pull data from Oracle?
yes.... example: select *from employee; dml command in sql language
How many syntaxes has the INSERT SQL command?
One can find more information about how many syntaxes have the INSERT SQL command from the following websites: Stack Overflow, Microsoft and Wikipedia.
How do you add or delete records to a database table?
It depends on the database, but most use some version of something called "structured query language" or SQL, and in that the normal command for adding a record is INSERT while the command for deleting records is DELETE. Look those up in the documentation for your particular database to find the exact syntax it's expecting.
Many versions of SQL require you to end a command with a?
semicolon (;)
