· 8 years ago · Jul 18, 2018, 04:46 PM
1 if not exists(
2 select*from INFORMATION_SCHEMA.TABLES t
3 where t.TABLE_NAME='tblUserAccess'
4 )
5 begin
6 CREATE TABLE STD.tblUserAccess
7 (
8 AccesId INT NOT NULL identity(1,1) PRIMARY KEY
9 ,UserAutirice VARCHAR(50) NOT NULL
10 ,DateInsert smalldatetime NOT NULL
11 ,State VARCHAR(30)
12 ,IsDelete bit NOT NULL
13 )
14end
15go