Discussion
Which of the following is the correct syntax for creating a table in SQL ?
Answer: A
The correct syntax is CREATE TABLE table_name (column1 datatype, column2 datatype,...) ;
In SQL a table is created with the DDL command CREATE TABLE, followed by the table name and, in brackets, each column with its data type and any constraints.
ADD TABLE, NEW TABLE and TABLE CREATE are not SQL commands. (ADD is used inside ALTER TABLE to add a column.)
No comment is present. Be the first to comment.
Loading…
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development