Find Recently Modified Tables In SQL Server Database. SQL Server maintains a table to keep information about each tables that are created in appropriate databases. Its a System Table called as sys.tables.
SQL Server maintains a table to keep information about each tables that are created in appropriate databases. Its a System Table called as sys.tables. For every table created to the database, a new one record is created in the sys.tables table which contains information such as table name, object id of table, created date, modified date, etc.
1 | SELECT
SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.
List of Available Database for Current User In SQL Server. Do you know yet? Let's explore it with us now.
This is part 3 of “MS SQL Server- Zero to Hero” and in this article, we will be discussing about the SCHEMAS in SQL SERVER. Before getting into this article, please consider to visit previous articles in this series from below.
In SSMS, we many of may noticed System Databases under the Database Folder. But how many of us knows its purpose?. In this article lets discuss about the System Databases in SQL Server.
Understanding various SQL Server system databases and their roles is an excellent aid for managing your SQL Server instance.