What is the difference between truncate and drop statements?
No Answer is Posted For this Question
Be the First to Post Answer
How do I find duplicates in the same column?
What are sql functions? Describe the different types of sql functions?
How can we avoid duplicating records in a query?
What is Highwatermark?
What are the different dml commands in sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Why do we use set serveroutput on?
How can triggers be used for the table auditing?
What is not null in sql?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
How does sql store data?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)