Does truncate remove indexes?
No Answer is Posted For this Question
Be the First to Post Answer
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 to include character strings in sql statements? : Sql dba
How can u find column name from a table which have max value in a row.( not max value)
HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP
what is the difference between to_char and to_date functions?
how to return query output in html format? : Sql dba
What is the difference between a query and a report?
what are the difference between clustered and a non-clustered index? : Sql dba
how instead of triger is helpful for mutating tables errors handlling ?
What is mutating error in pl sql?
Where not exists in sql?
What is varray in pl sql?
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)