Data definition language: Difference between revisions

Content deleted Content added

Revision as of 17:18, 27 November 2024 edit 49.185.161.75 (talk) No edit summary Tags: Reverted Visual edit Mobile edit Mobile web edit ← Previous edit		Latest revision as of 19:09, 27 November 2024 edit undo Mindmatrix (talk \| contribs) Autopatrolled, Administrators 188,543 edits m Reverted edits by 49.185.161.75 (talk) to last version by WalkingRadiance Tag: Rollback
(2 intermediate revisions by one other user not shown)
Line 64: The ''DROP'' statement destroys an existing database, table, index, or view. A ''DROP'' statement in [[SQL]] removes a component from a [[relational database management system]] (RDBMS). The types of objects that can be dropped depends on which RDBMS is being used, but most support the dropping of [[table (database)\|tables]], [[user (database)\|users]], and ~~databases~~[[database]]s. Some systems (such as [[PostgreSQL]]) allow DROP and other DDL commands to occur inside of a [[database transaction\|transaction]] and thus be [[rollback (data management)\|rolled back]]. The typical usage is simply: DROP ''objecttype'' ''objectname''.