alter-table Archives - Page 2 of 3

How can I modify the size of column in a MySQL table?

I have created a table and accidentally put varchar length as 300 instead of 65353. How can I fix that? An example would ...

May 16, 2022
0 Comments

How do I rename a column in a SQLite database table?

I would need to rename a few columns in some tables in a SQLite database. I know that a similar question has been ...

May 15, 2022
0 Comments

Altering column size in SQL Server

How to change the column size of the salary column in the employee table from numeric(18,0) to numeric(22,5) 10 Answers 10

May 12, 2022
0 Comments

How do you change the datatype of a column in SQL Server?

I am trying to change a column from a varchar(50) to a nvarchar(200). What is the SQL command to alter this table? 10 ...

May 9, 2022
0 Comments

How to rename a table in SQL Server?

The SQL query that I have used is : ALTER TABLE oldtable RENAME TO newtable; But, it gives me an error. Server: Msg ...

May 7, 2022
0 Comments

Error renaming a column in MySQL

How do I rename a column in table xyz? The columns are: Manufacurerid, name, status, AI, PK, int I want to rename to ...

May 6, 2022
0 Comments

Adding multiple columns AFTER a specific column in MySQL

I need to add multiple columns to a table but position the columns after a column called lastname. I have tried this: ALTER ...

May 6, 2022
0 Comments

How to delete a column from a table in MySQL

Given the table created using: CREATE TABLE tbl_Country ( CountryId INT NOT NULL AUTO_INCREMENT, IsDeleted bit, PRIMARY KEY (CountryId) ) How can I ...

May 4, 2022
0 Comments

Adding an identity to an existing column

I need to change the primary key of a table to an identity column, and there’s already a number of rows in table. ...

May 3, 2022
0 Comments

Check if a temporary table exists and delete if it exists before creating a temporary table

I am using the following code to check if the temporary table exists and drop the table if it exists before creating again. ...

April 25, 2022
0 Comments