Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,380 reads
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,380 reads
2012-12-07
2,122 reads
This helps to get list of all objects in a particular schemas.
2012-08-13 (first published: 2012-08-08)
1,081 reads
2011-08-31 (first published: 2011-08-24)
2,361 reads
A Technique to deal with moving data from multiple schemas into one table
2010-08-09
6,354 reads
2010-07-28
3,187 reads
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
2010-06-22
606 reads
I have several objects, all in the same schema. Because of this, ownership chaining is working, as described in this previous tip. However, I don't want ownership chaining to be on, but I need the objects to remain in the same schema. How can I do this?
2009-08-21
3,302 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
SQL Server 2005 implemented the concept of a database object schema. A schema is a distinct namespace to facilitate the separation, management, and ownership of database objects. It removed the tight coupling of database objects and owners to improve the security administration of database objects. Database object schemas offer functionality to control and help secure application objects within a database environment not available in previous versions of SQL Server.
2009-07-17
4,124 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers