Compare column names between two tables in SQL Server

PRA

SOLVED CLOSED ACTIVE ANSWERED
User: PRA
Posted: on Jul 07, 2021 05:27 AM
Forum: SQL Server
Answer: 1
Views: 4430

Hi!

I have two tables. I want compare two table and show difference columns name.

CREATE TABLE [dbo].[tblOne](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [nchar](10) NULL,
    [address] [nchar](10) NULL,
    [dob] [date] NULL
) 
CREATE TABLE [dbo].[tblTwo](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [lname] [nchar](10) NULL,
    [name] [nchar](10) NULL,
    [dob] [date] NULL,
    [address] [nchar](10) NULL,
    [phone] [int] NULL,
    [age] [int] NULL
)
select * from tblOne
minus
select * from tblTwo

I want show in result lname, phone and age because in three columns haven't on tblOne.

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Jul 07, 2021 05:46 AM
Report

Hi PRA,

Use below query.

SELECT A.Column_Name
FROM Information_Schema.Columns A
FULL OUTER JOIN Information_Schema.Columns B ON A.Column_Name = B.Column_Name
	AND B.Table_Schema = 'dbo' AND B.Table_Name = 'tblOne'
WHERE A.Table_Schema = 'dbo' AND A.Table_Name = 'tblTwo'
	AND (A.Column_Name IS NULL OR B.Column_Name IS NULL)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Compare column names between two tables in SQL Server

Company

Explore

Follow us

Contact Us