How do I create a table in SQL?

How do I create a table in SQL?

To create a table in SQL, you can use the CREATE TABLE statement. For example: CREATE TABLE Students (ID int, Name varchar(255), Age int);

What if I want to add a primary key?

You can define a primary key by adding PRIMARY KEY to the column definition. For example: CREATE TABLE Students (ID int PRIMARY KEY, Name varchar(255), Age int);

Can I create a table with foreign keys?

Yes, you can create foreign keys to establish relationships between tables. For example: CREATE TABLE Courses (CourseID int PRIMARY KEY, StudentID int, FOREIGN KEY (StudentID) REFERENCES Students(ID));

How do I modify an existing table?

You can use the ALTER TABLE statement. For example, to add a new column: ALTER TABLE Students ADD Email varchar(255);