|
|
-
HashamNiaz Learned 2 Years ago through Just Learned
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
HashamNiaz Learned 2 Years ago through Just Learned
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
HashamNiaz Liked 2 Years ago through Just Learned
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code...
|
-
HashamNiaz Liked 2 Years ago through Just Learned
While dropping a table present in a different database, you can use the fully qualified Table Name ("DatabaseName.SchemaName.TableName" format) and drop the table as shown below.
[code]
DROP TABLE AdventureWorks.HumanResources.Department
GO
[/code]
|
-
HashamNiaz Learned 2 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
HashamNiaz Liked 2 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
HashamNiaz Liked 2 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
HashamNiaz Learned 2 Years ago through Just Learned
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
HashamNiaz knew 2 Years ago through Just Learned
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|
-
HashamNiaz knew 2 Years ago through Just Learned
SQL Server job history contains only last 100 records.
To change or to grow history log
Go to SQL server Agent's Property
Click on -> History
change 1) Maximum job history log
2) Maximum job history rows per job......
|