Course Hero Logo

word dbms.docx - Combination of more than one column can be...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 3 pages.

Combination of more than one column can be as a primary. there is no requirement that a primary key have onlyone primary keyTheCREATE DATABASEstatement is used to create a new SQL database.TheCREATE TABLEstatement is used to create a new table in a database.The column parameters specify the names of the columns of the table.The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).TheALTER TABLEstatement is used to add, delete, or modify columns in an existing tableTheALTER TABLEstatement is also used to add and drop various constraints on an existing table.(ADD,DROP,MODIGY)DESCRIBEstatement is used more to obtain information about a table structureThePRIMARY KEYconstraint uniquely identifies each record in a table.Primary keys must contain UNIQUE values, and cannot contain NULL values.A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns(fields).

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
N/A
Tags
CREATE TABLE statement

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture