这条语句是在判断是否有 STUDENT 这张表,如果有的话就删除!OBJECT_ID() 其实是一个系统函数用于返回对象标识号,因为在SQL-Server 中 在一个数据库中不存在相同的表名,而且每个表名都进行了ID标识 ,所以可以用这个函数来判断是否有某个对象的存在.
IF OBJECT_ID(N'STUDENT') IS NOT NULL DROP TABLE STUDENT GO 这
1个回答
相关问题
-
数据库中if OBJECT_ID ('dbo.table_test_6_1','u') is not null drop
-
Jim is not a student.Tom is not a student,either同义句
-
Jim is not a student.Tom is not a student.合并为一个句子
-
Jim is not a student.Tom is not a student,either.(合为一个句子）
-
you are not a good student in China, so I think if you go to
-
If a student is ill ,does he usually go to school or stay at
-
英语翻译He is not a student,is he?yes,he is.He is a student ,isn
-
Is she not my student?与Isn't she my student?的区别
-
select * from table_a a where a.id not in (id1,id2,id3.) 中的i
-
She is not a student.She is a teacher.