• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
  • 4.6 TrustPilot
0
Sell
Where do you study
Your language
Start selling Create your account
  • Data Management Applications
  • Data Management Applications
To add items to your wishlist, you must be logged in
Document preview thumbnail
Preview 1 out of 3 pages
Exam (elaborations)

Data Mangement - Applications (D427)

0.0
(0 reviews)
- sold
3 pages
2024/2025 Written for academic year
Institution Data Management Applications
Course Data Management Applications
Document preview thumbnail
Preview 1 out of 3 pages

Data Mangement - Applications (D427)

Content preview

9/11/24, 2:38 Data Mangement - Applications
PM (D427)



Create Table
CREATE TABLE table_name (
column_1 data_type
constraint, column_2
data_type constraint,
column_3 data_type
constraint );




Delete Table
DROP TABLE table_name;


Alter Columns
Add Column
ALTER TABLE table_name
ADD COLUMN column_name data_type;
Remove Column
ALTER TABLE table_name
DROP COLUMN
column_name; Change
Column
ALTER TABLE table_name
CHANGE COLUMN CurrentColumnName NewColumnName NewDataType;
Modify Column
ALTER TABLE table_name
MODIFY COLUMN ColumnName NewDataType NewConstraints;


Add Constraint
ALTER TABLE table_name
ADD CONSTRAINT constraint_name


Constraints
PRIMARY KEY
UNIQUE
NOT NULL
DEFAULT value
AUTO_INCREMENT
UNSIGNED positive numbers, SIGNED negative




about:blan 1/
k 3

Document information

Uploaded on
September 11, 2024
Number of pages
3
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers
Report Copyright Violation
$11.49
Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF
Seller avatar
EXAMSHAVEN1
Sold
2
Followers
0
Items
966
Last sold
1 year ago

Browse related subjects

Subjects

  • data mangement applications d427

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Learn more Create citation
Working on your references?

Frequently asked questions