Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Schema Rss

   Items 1 to 18 of 18   
 

Default schema

By Anoo S Pillai 2014/03/31 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 1,795 reads

Schema & Renaming Fun

By Andy Warren 2014/03/12 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 1,732 reads

Auto dump out database schema

This powershell script will dump out a database schema to a text file.  Read more...
By Neil Bryan 2014/02/04 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,316 reads

Find Foriegn Keys and their details in a database

Use this script to find all the Foriegn Keys and their details in a database  Read more...
By Bodhisatya Mookherjee 2013/09/11 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 1,310 reads

Which Statement will execute sucessfully

By malls reddy 2012/12/07 | Category: schema
Rating: (not yet rated) |  Discuss |   Briefcase | 2,072 reads

List of objects from particular schemas

This helps to get list of all objects in a particular schemas.  Read more...
By Nitesh Dedhia 2012/08/13 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 985 reads

Copy One Schema to Another Schema

This script copies one object in another multiple schema.  Read more...
By Vinay Kumar 2011/08/31 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,134 reads

default schema trouble

By Nils Gustav Stråbø 2010/07/28 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,145 reads

The Schema Debate

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.  Read more...
By Steve Jones 2010/06/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 541 reads

Breaking ownership chaining within a schema in SQL Server

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?  Read more...
By Additional Articles 2009/08/21 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 2,686 reads

Granting limited permissions to create views in another schema in SQL Server - Part 2

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.  Read more...
By Additional Articles 2009/08/17 | Source: MSSQLTips.com | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 2,741 reads

SQL Server Best Practices - Implementation of Database Object Schemas

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.  Read more...
By Additional Articles 2009/07/17 | Source: TechNet Blogs | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,655 reads

Object Grouping Best Practices: Using Schemas for Logical Separation

You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,  Read more...
By Hugo Shebbeare 2009/07/14 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,102 reads

Using the OBJECT_SCHEMA_NAME function to return the schema name

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.   Read more...
By Additional Articles 2009/06/22 | Source: MSSQLTips.com | Category: schema
Rating: (not yet rated)  Rate this |   Briefcase | 2,668 reads

Creating a recycle bin for SQL Server 2005\2008

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.   Read more...
By Chris Goldsmith 2009/05/20 | Source: SQLServerCentral.com | Category: ddl triggers
Rating: |  Discuss |   Briefcase | 11,739 reads

Using schema binding to improve SQL Server UDF performance

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.  Read more...
By Additional Articles 2009/03/09 | Source: MSSQLTips.com | Category: schema
Rating:  Rate this |   Briefcase | 3,617 reads

View - Table Usage (Recursive)

Written to explore the table dependencies of a view, especially when the view queries other views.  Read more...
By Rhett Clement 2009/01/22 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 998 reads

Getting schemas for your tables

A short script you can incorporate into any 2005/2008 code to get the full schema.table.  Read more...
By Gaby Abed 2008/09/29 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 622 reads
   Items 1 to 18 of 18   
 
Tags
t-sql (5)    
security (4)    
ddl triggers (2)    
blogs (1)    
database design (1)    
dependencies (1)    
editorial (1)    
foreign keys (1)    
information_schema (1)    
list of objects (1)    
ownership chaining (1)    
powershell (1)    
quotename (1)    
recursive function (1)    
recycle bin (1)    
rename (1)    
sql server 2005 (1)    
sql server 2008 (1)    
user defined function (udf) (1)