Efficient Table Migration to a New Schema in T-SQL
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2023-11-03
2,587 reads
This article will explain why and how you can easily move tables to new schemas if the need arisees.
2023-11-03
2,587 reads
2014-03-31
1,930 reads
2014-03-12
1,863 reads
Use this script to find all the Foriegn Keys and their details in a database
2013-09-11 (first published: 2013-09-02)
1,409 reads
2012-12-07
2,125 reads
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,103 reads
In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.
2009-08-17
3,444 reads
I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
2009-06-22
3,158 reads
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.
2009-03-09
4,200 reads
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,187 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers