SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE students ( id INTEGER PRIMARY KEY, name VARCHAR(50) NOT NULL, gender VARCHAR(50) NOT NULL ); -- Alter table students add IND INTEGER NULL; ALTER TABLE students ALTER column IND BIGINT; INSERT into students (ID, name, gender, IND) VALUES (1,'T1','M',0); SELECT * FROM students; EXEC sp_rename 'students.ind', 'ind1', 'COLUMN'; alter table students drop column ind1; SELECT * FROM students;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear