如何在SQL中没有主键字段的表中从列中获取列？ [英] How to fetch columns from a table without primary key field in SQL?

问题描述

我想从sql中没有主键字段的表中获取列。



我从表中获取列。我想在没有主键列字段的情况下获取



我尝试了什么：

 SELECT COLUMN_NAME，''作为ValidateMsg 
来自INFORMATION_SCHEMA.COLUMNS 
 WHERE TABLE_NAME ='ICCS_REP_ICCSC01'
 AND TABLE_SCHEMA ='dbo'
 

解决方案

  SELECT  COLUMN_NAME  FROM  INFORMATION_SCHEMA.COLUMNS  WHERE  TABLE_NAME = '  TableName'  AND  TABLE_SCHEMA = '  dbo' 
    SELECT  column_name  FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS  AS  TC 
  INNER   JOIN  INFORMATION_SCHEMA.KEY_COLUMN_USAGE  AS  KU  ON  TC.CONSTRAINT_TYPE = '  PRIMARY KEY'  AND  TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME  AND  KU.table_name = '  TableName' 

来自SQL Server：使用sql查询获取表主键 - Stack Overflow [ ^ ]

I want to fetch columns from a table without primary key field in sql.

I am fetching columns from a table . I want to fetch without primary key column field

What I have tried:

SELECT COLUMN_NAME,'' as  ValidateMsg
       FROM INFORMATION_SCHEMA.COLUMNS
       WHERE TABLE_NAME = 'ICCS_REP_ICCSC01'
       AND TABLE_SCHEMA='dbo'

解决方案

SELECT COLUMN_NAME  FROM INFORMATION_SCHEMA.COLUMNS   WHERE TABLE_NAME = 'TableName'  AND TABLE_SCHEMA='dbo'
except SELECT   column_name   FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC
INNER JOIN     INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KU   ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME AND   KU.table_name='TableName'

referred from SQL Server: Get table primary key using sql query - Stack Overflow[^]

这篇关于如何在SQL中没有主键字段的表中从列中获取列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！