执行你上面那句命令报Incorrect syntax near 'sys'.的错误

如果您在 SQL Server 中执行该命令时遇到 "Incorrect syntax near 'sys'" 错误，可能是由于您的 SQL Server 版本太低导致的。在 SQL Server 2005 或更早版本中，可能不支持使用 sys.foreign_keys 系统视图。

在这种情况下，您可以尝试使用以下命令查看 DocBase 表的外键关联情况：

SELECT
  FK.name AS ForeignKey,
  TP.name AS ParentTable,
  TR.name AS ReferenceTable
FROM
  sys.foreign_keys FK
  INNER JOIN sys.tables TP ON FK.parent_object_id = TP.object_id
  INNER JOIN sys.tables TR ON FK.referenced_object_id = TR.object_id
WHERE
  TP.name = 'DocBase'

其中，'DocBase' 是要查看外键关联的表的名称，可以根据实际情况修改。

此命令也会列出 DocBase 表作为外键父表或外键子表的所有外键关联的名称和相关表的名称。

相关问题

Incorrect syntax near 'FORCE'.

This error message typically occurs in SQL when the keyword "FORCE" is used incorrectly or in an unsupported way.

Here are a few possible causes and solutions for this error:

1. Using "FORCE" as a keyword in a SQL statement:
- Solution: "FORCE" is not a valid SQL keyword, so you should remove it or replace it with a valid keyword.

2. Using "FORCE" as a column name or table name:
- Solution: If you have a column or table named "FORCE", you should rename it to something else. "FORCE" is not a good name for a database object because it is a reserved keyword in some contexts.

3. Using "FORCE" in a statement that is not supported by your database system:
- Solution: Some SQL statements or clauses may not be supported by all database systems, so you should check the documentation for your database to see if "FORCE" is a valid keyword. If it is not, you may need to rephrase your statement or use a different approach.

Overall, the best way to avoid this error is to carefully review your SQL code and make sure that all keywords, identifiers, and statements are valid and supported by your database system.

sqlserver select * from a join fetch a.b 报incorrect syntax near the keyword fetch

在SQL Server中，`JOIN FETCH` 是一个用于联合查询并获取特定结果集扩展的功能，但它并不是标准的SQL语法，而是Oracle数据库特有的扩展功能。在SQL Server中，如果你想要从表A中连接并获取表B的相关记录，通常会使用 `INNER JOIN` 或 `LEFT JOIN` 等基本的联接操作。

正确的语法可能是这样的：

SELECT *
FROM a
INNER JOIN a.b ON a.common_column = b.common_column;

这里假设`a`表和`b`表之间有一个共同的列`common_column`作为关联条件。

如果你只是想一次返回两表的所有数据，可以考虑两次查询或者使用UNION ALL：

SELECT * FROM a
UNION ALL
SELECT * FROM a.b;

但是请注意，这将返回所有行的组合，而不是像`JOIN FETCH`那样基于关联条件只返回额外的数据。

如果`fetch`是你试图表示某个特定的行为或限制结果集，你应该查看SQL Server的其他关键字，比如`TOP`, `OFFSET`等。