一个sql语句的问题
来源:百度知道 编辑:UC知道 时间:2024/06/27 05:36:04
select * from dbo.sysobjects
where id = object_id(N'dbo.ShopsStockReport') and OBJECTPROPERTY(id, N'IsUserTable') = 1
高手帮我解释一下上面语句的意思,尤其是object_id(N'dbo.ShopsStockReport') 和OBJECTPROPERTY(id, N'IsUserTable') = 1,谢谢了
where id = object_id(N'dbo.ShopsStockReport') and OBJECTPROPERTY(id, N'IsUserTable') = 1
高手帮我解释一下上面语句的意思,尤其是object_id(N'dbo.ShopsStockReport') 和OBJECTPROPERTY(id, N'IsUserTable') = 1,谢谢了
object_id(N'dbo.ShopsStockReport')
是取得这个外键的ID号,每个元素在数据库中都有唯一的ID号
OBJECTPROPERTY(id, N'IsUserTable') = 1
判断ID是否是外键
select * from dbo.sysobjects
where id = object_id(N'dbo.ShopsStockReport') and OBJECTPROPERTY(id, N'IsUserTable') = 1
这条语句的意思是取表ShopsStockReport存放数据库元素信息,也就是只取指定ID号的那个外键的信息
函数吧