Delete row within a table

Guest User

5y705

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]

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
if it didn't work then use the simple one
ALTER TABLE CourseNo ADD Url VARCHAR(250) DEFAULT 'Introduction to meta'
Guest User5y ago
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 User5y ago
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
Sachin Singh5y ago
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
Guest User5y ago
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';
Sachin Singh5y ago
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;
Guest User5y ago
Hi

yes just the column
Sachin Singh5y ago
what you want is to delete a Column not a row.
Row means hrizontal
Column means vertical
ALTER TABLE TableName
DROP COLUMN Columnname;