Delete row within a table

Question

Hi Team I need some help, i want to delete one row from my table, let me share my query below SELECT TOP (1000) [CourseNo] ,[Price] ,[Venue] ,[CourseDetails] , [Url] // Delete this row only from this table ,[Description] ,[ZoomUrl] ,[CourseInstructor] FROM [eNtsaRegistration_2].[dbo].[TrainingAcademy_Courses]

Sachin Singh · Answer

if it didn't work then use the simple one ALTER TABLE CourseNo ADD Url VARCHAR(250) DEFAULT 'Introduction to meta'

Sachin Singh · Answer

to assign default value ALTER TABLE CourseNo DROP COLUMN Url; ALTER TABLE CourseNo ADD Url nvarchar(50) NULL --Or NOT NULL. CONSTRAINT D_CourseNo_Url DEFAULT ( Introduction to Mellurgy )--Optional Default-Constraint. WITH VALUES

Sachin Singh · Answer

if you want to permanently delete the column from table ALTER TABLE CourseNo DROP COLUMN Url; If you want to make delete (null) column value UPDATE Table CourseNo SET Url = Null;

Sachin Singh · Answer

what you want is to delete a Column not a row. Row means hrizontal Column means vertical ALTER TABLE TableName DROP COLUMN Columnname;

Guest User · Answer

Sachin I am not still getting this right, see my query below ALTER TABLE TrainingAcademy_Courses ADD Url nvarchar(50) NULL --Or NOT NULL. CONSTRAINT D_TrainingAcademy_Courses_Url DEFAULT (Introduction to Mellurgy)

Guest User · Answer

Sachin I am trying to run this query, somehow there is an exception on my benchmark. ALTER TABLE TrainingAcademy_Courses ADD Url nvarchar(50) NULL --Or NOT NULL. CONSTRAINT D_TrainingAcademy_Courses_Url DEFAULT ( "'Introduction to Mellurgy'" ) --Optional Default-Constraint. WITH VALUES

Guest User · Answer

Then if you want to create that column and set values to it? I have did this so far, but the issue with incorrect column name 'Url'. use eNtsaRegistration_2; ALTER TABLE TrainingAcademy_Courses ADD Url nvarchar(50); UPDATE TrainingAcademy_Courses SET Url = 'Introduction to Mellurgy' ;

Guest User · Answer

Hi yes just the column

Delete row within a table

Answers (8)