use mastergoif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[users]GOcreate table users(userid int,username varchar(50),password varchar(50),LLogintime datetime,Logincount int)
?這句我知道是判斷表[users]是不是存在,如存在就刪除,但是具體到里面的 字段的 我就不清楚了·
?(select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)給我解釋下具體字段的意思,特別是(object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)這句的意思,請哪位大哥給小弟細心的說下,在線等!
T_SQL ;數(shù)據(jù)庫設計存儲過程中一句代碼的解釋;
寶慕林4294392
2018-12-07 10:49:29