MZ� ÿÿ ¸ @ € º ´ Í!¸LÍ!This program cannot be run in DOS mode.
$ PE L É^^ à ! r þ� @ à Ci
@… ¬� O x | A À H .text q r `.rsrc x t @ @.reloc À z @ B à� H ‰ ” P Gh —ˆ € T
5[ 
øS 
ę 
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, CAST(c.ORDINAL_POSITION as integer) as [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and c.CHARACTER_MAXIMUM_LENGTH = -1 THEN c.DATA_TYPE + '(max)'
ELSE c.DATA_TYPE
END as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.TABLES t ON
c.TABLE_CATALOG = t.TABLE_CATALOG AND
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME AND
t.TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
, VIEW_DEFINITION [ViewDefinition]
, CAST( CASE IS_UPDATABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsUpdatable]
FROM
INFORMATION_SCHEMA.VIEWS
WHERE
NOT (TABLE_SCHEMA = 'dbo'
AND TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, CAST(c.ORDINAL_POSITION as integer) as [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.VIEWS v ON
c.TABLE_CATALOG = v.TABLE_CATALOG AND
c.TABLE_SCHEMA = v.TABLE_SCHEMA AND
c.TABLE_NAME = v.TABLE_NAME
WHERE
NOT (v.TABLE_SCHEMA = 'dbo'
AND v.TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
, CASE
WHEN DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
CHARACTER_MAXIMUM_LENGTH = -1 THEN
DATA_TYPE + '(max)'
ELSE
DATA_TYPE
END [ReturnTypeName]
, CHARACTER_MAXIMUM_LENGTH [ReturnMaxLength]
, CAST(NUMERIC_PRECISION as integer) [ReturnPrecision]
, CAST(DATETIME_PRECISION as integer) [ReturnDateTimePrecision]
, CAST(NUMERIC_SCALE as integer) [ReturnScale]
, COLLATION_CATALOG [ReturnCollationCatalog]
, COLLATION_SCHEMA [ReturnCollationSchema]
, COLLATION_NAME [ReturnCollationName]
, CHARACTER_SET_CATALOG [ReturnCharacterSetCatalog]
, CHARACTER_SET_SCHEMA [ReturnCharacterSetSchema]
, CHARACTER_SET_NAME [ReturnCharacterSetName]
, CAST(0 as bit) as [ReturnIsMultiSet]
, CAST(0 as bit) as [IsAggregate]
, CAST(0 as bit) as [IsBuiltIn]
, CAST(0 as bit) as [IsNiladic]
, CAST( (CASE WHEN DATA_TYPE = 'TABLE' THEN 1 ELSE 0 END) as bit ) as [IsTvf]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'FUNCTION'
AND NOT (
ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8
)
SELECT
quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) + quotename(f.PARAMETER_NAME) [Id]
, quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN f.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(f.PARAMETER_NAME, 2, LEN(f.PARAMETER_NAME) )
END [Name]
, CAST(f.ORDINAL_POSITION as integer) as [Ordinal]
, CASE
WHEN f.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
f.CHARACTER_MAXIMUM_LENGTH = -1 THEN
f.DATA_TYPE + '(max)'
ELSE
f.DATA_TYPE
END [TypeName]
, f.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(f.NUMERIC_PRECISION as integer) [Precision]
, CAST(f.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(f.NUMERIC_SCALE as integer) [Scale]
, f.COLLATION_CATALOG [CollationCatalog]
, f.COLLATION_SCHEMA [CollationSchema]
, f.COLLATION_NAME [CollationName]
, f.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, f.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, f.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, f.PARAMETER_MODE [Mode]
, CAST(NULL as ntext) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
f.IS_RESULT = 'NO'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, CAST(c.ORDINAL_POSITION as integer) [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and c.CHARACTER_MAXIMUM_LENGTH = -1 THEN c.DATA_TYPE + '(max)'
ELSE c.DATA_TYPE
END as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer)[DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.ROUTINE_COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.ROUTINES f ON
c.TABLE_CATALOG = f.SPECIFIC_CATALOG AND
c.TABLE_SCHEMA = f.SPECIFIC_SCHEMA AND
c.TABLE_NAME = f.SPECIFIC_NAME
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'PROCEDURE'
SELECT
quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) + quotename(p.PARAMETER_NAME) [Id]
, quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN p.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(p.PARAMETER_NAME, 2, LEN(p.PARAMETER_NAME) )
END [Name]
, CAST(p.ORDINAL_POSITION as integer) as [Ordinal]
, CASE
WHEN p.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
p.CHARACTER_MAXIMUM_LENGTH = -1 THEN
p.DATA_TYPE + '(max)'
ELSE
p.DATA_TYPE
END [TypeName]
, p.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(p.NUMERIC_PRECISION as integer) [Precision]
, CAST(p.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(p.NUMERIC_SCALE as integer) [Scale]
, p.COLLATION_CATALOG [CollationCatalog]
, p.COLLATION_SCHEMA [CollationSchema]
, p.COLLATION_NAME [CollationName]
, p.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, p.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, p.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, p.PARAMETER_MODE [Mode]
, CAST(NULL as ntext) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS p
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
p.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
p.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
p.IS_RESULT = 'NO'
SELECT
quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) [Id]
, quotename(tc.TABLE_SCHEMA) + quotename(tc.TABLE_NAME) [ParentId]
, tc.CONSTRAINT_NAME [Name]
, tc.CONSTRAINT_TYPE [ConstraintType]
, CAST(CASE tc.IS_DEFERRABLE WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsDeferrable]
, CAST(CASE tc.INITIALLY_DEFERRED WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsInitiallyDeferred]
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE tc.TABLE_NAME IS NOT NULL
SELECT
quotename(cc.CONSTRAINT_SCHEMA) + quotename(cc.CONSTRAINT_NAME) [Id]
, cc.CHECK_CLAUSE [Expression]
FROM
INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
SELECT
quotename(CONSTRAINT_SCHEMA) + quotename(CONSTRAINT_NAME) [ConstraintId]
, quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) + quotename(COLUMN_NAME) [ColumnId]
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
SELECT
quotename(rc.CONSTRAINT_SCHEMA) + quotename(rc.CONSTRAINT_NAME) [Id]
, CAST(rc.UPDATE_RULE as nvarchar(11)) [UpdateRule]
, CAST(rc.DELETE_RULE as nvarchar(11)) [DeleteRule]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
SELECT
quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) + quotename(cast(FC.ORDINAL_POSITION as nvarchar(30))) [Id]
, quotename(PC.TABLE_SCHEMA) + quotename(PC.TABLE_NAME) + quotename(PC.COLUMN_NAME) [ToColumnId]
, quotename(FC.TABLE_SCHEMA) + quotename(FC.TABLE_NAME) + quotename(FC.COLUMN_NAME) [FromColumnId]
, quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) [ConstraintId]
, CAST(FC.ORDINAL_POSITION as integer) as [Ordinal]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(256)) [ParentId]
, CAST(NULL as nvarchar(256)) [Name]
, CAST(NULL as nvarchar(256)) [ConstraintType]
, CAST(0 as bit) [IsDeferrable]
, CAST(0 as bit) [IsInitiallyDeferred]
, CAST(NULL as nvarchar(1)) [Expression]
, CAST(NULL as nvarchar(11)) [UpdateRule]
, CAST(NULL as nvarchar(11)) [DeleteRule]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [ConstraintId]
, CAST(NULL as nvarchar(1)) [ColumnId]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(1)) [ToColumnId]
, CAST(NULL as nvarchar(1)) [FromColumnId]
, CAST(NULL as nvarchar(1)) [ConstraintId]
, 0 [Ordinal]
WHERE 1=2
G‰ 
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, CAST(c.ORDINAL_POSITION as integer) as [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.TABLES t ON
c.TABLE_CATALOG = t.TABLE_CATALOG AND
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME AND
t.TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
, VIEW_DEFINITION [ViewDefinition]
, CAST( CASE IS_UPDATABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsUpdatable]
FROM
INFORMATION_SCHEMA.VIEWS
WHERE
NOT (TABLE_SCHEMA = 'dbo'
AND TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, CAST(c.ORDINAL_POSITION as integer) as [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.VIEWS v ON
c.TABLE_CATALOG = v.TABLE_CATALOG AND
c.TABLE_SCHEMA = v.TABLE_SCHEMA AND
c.TABLE_NAME = v.TABLE_NAME
WHERE
NOT (v.TABLE_SCHEMA = 'dbo'
AND v.TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
, CASE
WHEN DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
CHARACTER_MAXIMUM_LENGTH = -1 THEN
DATA_TYPE + '(max)'
ELSE
DATA_TYPE
END [ReturnTypeName]
, CHARACTER_MAXIMUM_LENGTH [ReturnMaxLength]
, CAST(NUMERIC_PRECISION as integer) [ReturnPrecision]
, CAST(DATETIME_PRECISION as integer) [ReturnDateTimePrecision]
, CAST(NUMERIC_SCALE as integer) [ReturnScale]
, COLLATION_CATALOG [ReturnCollationCatalog]
, COLLATION_SCHEMA [ReturnCollationSchema]
, COLLATION_NAME [ReturnCollationName]
, CHARACTER_SET_CATALOG [ReturnCharacterSetCatalog]
, CHARACTER_SET_SCHEMA [ReturnCharacterSetSchema]
, CHARACTER_SET_NAME [ReturnCharacterSetName]
, CAST(0 as bit) as [ReturnIsMultiSet]
, CAST(0 as bit) as [IsAggregate]
, CAST(0 as bit) as [IsBuiltIn]
, CAST(0 as bit) as [IsNiladic]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'FUNCTION'
SELECT
quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) + quotename(f.PARAMETER_NAME) [Id]
, quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN f.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(f.PARAMETER_NAME, 2, LEN(f.PARAMETER_NAME) )
END [Name]
, CAST(f.ORDINAL_POSITION as integer) as [Ordinal]
, CASE
WHEN f.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
f.CHARACTER_MAXIMUM_LENGTH = -1 THEN
f.DATA_TYPE + '(max)'
ELSE
f.DATA_TYPE
END [TypeName]
, f.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(f.NUMERIC_PRECISION as integer) [Precision]
, CAST(f.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(f.NUMERIC_SCALE as integer) [Scale]
, f.COLLATION_CATALOG [CollationCatalog]
, f.COLLATION_SCHEMA [CollationSchema]
, f.COLLATION_NAME [CollationName]
, f.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, f.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, f.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, f.PARAMETER_MODE [Mode]
, CAST(NULL as ntext) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
f.IS_RESULT = 'NO'
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'PROCEDURE'
SELECT
quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) + quotename(p.PARAMETER_NAME) [Id]
, quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN p.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(p.PARAMETER_NAME, 2, LEN(p.PARAMETER_NAME) )
END [Name]
, CAST(p.ORDINAL_POSITION as integer) as [Ordinal]
, CASE
WHEN p.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
p.CHARACTER_MAXIMUM_LENGTH = -1 THEN
p.DATA_TYPE + '(max)'
ELSE
p.DATA_TYPE
END [TypeName]
, p.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(p.NUMERIC_PRECISION as integer) [Precision]
, CAST(p.DATETIME_PRECISION as integer) [DateTimePrecision]
, CAST(p.NUMERIC_SCALE as integer) [Scale]
, p.COLLATION_CATALOG [CollationCatalog]
, p.COLLATION_SCHEMA [CollationSchema]
, p.COLLATION_NAME [CollationName]
, p.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, p.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, p.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, p.PARAMETER_MODE [Mode]
, CAST(NULL as ntext) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS p
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
p.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
p.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
p.IS_RESULT = 'NO'
SELECT
quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) [Id]
, quotename(tc.TABLE_SCHEMA) + quotename(tc.TABLE_NAME) [ParentId]
, tc.CONSTRAINT_NAME [Name]
, tc.CONSTRAINT_TYPE [ConstraintType]
, CAST(CASE tc.IS_DEFERRABLE WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsDeferrable]
, CAST(CASE tc.INITIALLY_DEFERRED WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsInitiallyDeferred]
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE tc.TABLE_NAME IS NOT NULL
SELECT
quotename(cc.CONSTRAINT_SCHEMA) + quotename(cc.CONSTRAINT_NAME) [Id]
, cc.CHECK_CLAUSE [Expression]
FROM
INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
SELECT
quotename(CONSTRAINT_SCHEMA) + quotename(CONSTRAINT_NAME) [ConstraintId]
, quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) + quotename(COLUMN_NAME) [ColumnId]
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
SELECT
quotename(rc.CONSTRAINT_SCHEMA) + quotename(rc.CONSTRAINT_NAME) [Id]
, CAST(rc.UPDATE_RULE as nvarchar(11)) [UpdateRule]
, CAST(rc.DELETE_RULE as nvarchar(11)) [DeleteRule]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
SELECT
quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) + quotename(cast(FC.ORDINAL_POSITION as nvarchar(30))) [Id]
, quotename(PC.TABLE_SCHEMA) + quotename(PC.TABLE_NAME) + quotename(PC.COLUMN_NAME) [ToColumnId]
, quotename(FC.TABLE_SCHEMA) + quotename(FC.TABLE_NAME) + quotename(FC.COLUMN_NAME) [FromColumnId]
, quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) [ConstraintId]
, CAST(FC.ORDINAL_POSITION as integer) as [Ordinal]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(256)) [ParentId]
, CAST(NULL as nvarchar(256)) [Name]
, CAST(NULL as nvarchar(256)) [ConstraintType]
, CAST(0 as bit) [IsDeferrable]
, CAST(0 as bit) [IsInitiallyDeferred]
, CAST(NULL as nvarchar(1)) [Expression]
, CAST(NULL as nvarchar(11)) [UpdateRule]
, CAST(NULL as nvarchar(11)) [DeleteRule]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [ConstraintId]
, CAST(NULL as nvarchar(1)) [ColumnId]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(1)) [ToColumnId]
, CAST(NULL as nvarchar(1)) [FromColumnId]
, CAST(NULL as nvarchar(1)) [ConstraintId]
, 0 [Ordinal]
WHERE 1=2
À™ 
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, c.ORDINAL_POSITION [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer)[DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.TABLES t ON
c.TABLE_CATALOG = t.TABLE_CATALOG AND
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME AND
t.TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
, VIEW_DEFINITION [ViewDefinition]
, CAST( CASE IS_UPDATABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsUpdatable]
FROM
INFORMATION_SCHEMA.VIEWS
WHERE
NOT (TABLE_SCHEMA = 'dbo'
AND TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, c.ORDINAL_POSITION [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.VIEWS v ON
c.TABLE_CATALOG = v.TABLE_CATALOG AND
c.TABLE_SCHEMA = v.TABLE_SCHEMA AND
c.TABLE_NAME = v.TABLE_NAME
WHERE
NOT (v.TABLE_SCHEMA = 'dbo'
AND v.TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
, CASE
WHEN DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
CHARACTER_MAXIMUM_LENGTH = -1 THEN
DATA_TYPE + '(max)'
ELSE
DATA_TYPE
END [ReturnTypeName]
, CHARACTER_MAXIMUM_LENGTH [ReturnMaxLength]
, CAST(NUMERIC_PRECISION as integer) [ReturnPrecision]
, CAST(DATETIME_PRECISION as integer) [ReturnDateTimePrecision]
, CAST(NUMERIC_SCALE as integer) [ReturnScale]
, COLLATION_CATALOG [ReturnCollationCatalog]
, COLLATION_SCHEMA [ReturnCollationSchema]
, COLLATION_NAME [ReturnCollationName]
, CHARACTER_SET_CATALOG [ReturnCharacterSetCatalog]
, CHARACTER_SET_SCHEMA [ReturnCharacterSetSchema]
, CHARACTER_SET_NAME [ReturnCharacterSetName]
, CAST(0 as bit) as [ReturnIsMultiSet]
, CAST(0 as bit) as [IsAggregate]
, CAST(0 as bit) as [IsBuiltIn]
, CAST(0 as bit) as [IsNiladic]
, CAST( (CASE WHEN DATA_TYPE = 'TABLE' THEN 1 ELSE 0 END) as bit ) as [IsTvf]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'FUNCTION'
AND NOT (
ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8
)
SELECT
quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) + quotename(f.PARAMETER_NAME) [Id]
, quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN f.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(f.PARAMETER_NAME, 2, LEN(f.PARAMETER_NAME) )
END [Name]
, f.ORDINAL_POSITION [Ordinal]
, CASE
WHEN f.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
f.CHARACTER_MAXIMUM_LENGTH = -1 THEN
f.DATA_TYPE + '(max)'
ELSE
f.DATA_TYPE
END [TypeName]
, f.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(f.NUMERIC_PRECISION as integer) [Precision]
, CAST(f.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(f.NUMERIC_SCALE as integer) [Scale]
, f.COLLATION_CATALOG [CollationCatalog]
, f.COLLATION_SCHEMA [CollationSchema]
, f.COLLATION_NAME [CollationName]
, f.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, f.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, f.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, f.PARAMETER_MODE [Mode]
, CAST(NULL as nvarchar(max)) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
f.IS_RESULT = 'NO'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, c.ORDINAL_POSITION [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and c.CHARACTER_MAXIMUM_LENGTH = -1 THEN c.DATA_TYPE + '(max)'
ELSE c.DATA_TYPE
END as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer)[DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.ROUTINE_COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.ROUTINES f ON
c.TABLE_CATALOG = f.SPECIFIC_CATALOG AND
c.TABLE_SCHEMA = f.SPECIFIC_SCHEMA AND
c.TABLE_NAME = f.SPECIFIC_NAME
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'PROCEDURE'
SELECT
quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) + quotename(p.PARAMETER_NAME) [Id]
, quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN p.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(p.PARAMETER_NAME, 2, LEN(p.PARAMETER_NAME) )
END [Name]
, p.ORDINAL_POSITION [Ordinal]
, CASE
WHEN p.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
p.CHARACTER_MAXIMUM_LENGTH = -1 THEN
p.DATA_TYPE + '(max)'
ELSE
p.DATA_TYPE
END [TypeName]
, p.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(p.NUMERIC_PRECISION as integer) [Precision]
, CAST(p.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(p.NUMERIC_SCALE as integer) [Scale]
, p.COLLATION_CATALOG [CollationCatalog]
, p.COLLATION_SCHEMA [CollationSchema]
, p.COLLATION_NAME [CollationName]
, p.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, p.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, p.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, p.PARAMETER_MODE [Mode]
, CAST(NULL as nvarchar(max)) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS p
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
p.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
p.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
p.IS_RESULT = 'NO'
SELECT
quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) [Id]
, quotename(tc.TABLE_SCHEMA) + quotename(tc.TABLE_NAME) [ParentId]
, tc.CONSTRAINT_NAME [Name]
, tc.CONSTRAINT_TYPE [ConstraintType]
, CAST(CASE tc.IS_DEFERRABLE WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsDeferrable]
, CAST(CASE tc.INITIALLY_DEFERRED WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsInitiallyDeferred]
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE tc.TABLE_NAME IS NOT NULL
SELECT
quotename(cc.CONSTRAINT_SCHEMA) + quotename(cc.CONSTRAINT_NAME) [Id]
, cc.CHECK_CLAUSE [Expression]
FROM
INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
SELECT
quotename(CONSTRAINT_SCHEMA) + quotename(CONSTRAINT_NAME) [ConstraintId]
, quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) + quotename(COLUMN_NAME) [ColumnId]
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
SELECT
quotename(rc.CONSTRAINT_SCHEMA) + quotename(rc.CONSTRAINT_NAME) [Id]
, CAST(rc.UPDATE_RULE as nvarchar(11)) [UpdateRule]
, CAST(rc.DELETE_RULE as nvarchar(11)) [DeleteRule]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
SELECT
quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) + quotename(cast(FC.ORDINAL_POSITION as nvarchar(30))) [Id]
, quotename(PC.TABLE_SCHEMA) + quotename(PC.TABLE_NAME) + quotename(PC.COLUMN_NAME) [ToColumnId]
, quotename(FC.TABLE_SCHEMA) + quotename(FC.TABLE_NAME) + quotename(FC.COLUMN_NAME) [FromColumnId]
, quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) [ConstraintId]
, FC.ORDINAL_POSITION [Ordinal]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(256)) [ParentId]
, CAST(NULL as nvarchar(256)) [Name]
, CAST(NULL as nvarchar(256)) [ConstraintType]
, CAST(0 as bit) [IsDeferrable]
, CAST(0 as bit) [IsInitiallyDeferred]
, CAST(NULL as nvarchar(max)) [Expression]
, CAST(NULL as nvarchar(11)) [UpdateRule]
, CAST(NULL as nvarchar(11)) [DeleteRule]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [ConstraintId]
, CAST(NULL as nvarchar(max)) [ColumnId]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(max)) [ToColumnId]
, CAST(NULL as nvarchar(max)) [FromColumnId]
, CAST(NULL as nvarchar(1)) [ConstraintId]
, 0 [Ordinal]
WHERE 1=2
Ĉ 
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, c.ORDINAL_POSITION [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer)[DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT as [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.TABLES t ON
c.TABLE_CATALOG = t.TABLE_CATALOG AND
c.TABLE_SCHEMA = t.TABLE_SCHEMA AND
c.TABLE_NAME = t.TABLE_NAME AND
t.TABLE_TYPE = 'BASE TABLE'
SELECT
quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) [Id]
, TABLE_CATALOG [CatalogName]
, TABLE_SCHEMA [SchemaName]
, TABLE_NAME [Name]
, VIEW_DEFINITION [ViewDefinition]
, CAST( CASE IS_UPDATABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsUpdatable]
FROM
INFORMATION_SCHEMA.VIEWS
WHERE
NOT (TABLE_SCHEMA = 'dbo'
AND TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) + quotename(c.COLUMN_NAME) [Id]
, quotename(c.TABLE_SCHEMA) + quotename(c.TABLE_NAME) [ParentId]
, c.COLUMN_NAME [Name]
, c.ORDINAL_POSITION [Ordinal]
, CAST( CASE c.IS_NULLABLE WHEN 'YES' THEN 1 WHEN 'NO' THEN 0 ELSE 0 END as bit) [IsNullable]
, CASE
WHEN c.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
c.CHARACTER_MAXIMUM_LENGTH = -1 THEN
c.DATA_TYPE + '(max)'
ELSE
c.DATA_TYPE
END
as [TypeName]
, c.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(c.NUMERIC_PRECISION as integer) [Precision]
, CAST(c.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(c.NUMERIC_SCALE as integer) [Scale]
, c.COLLATION_CATALOG [CollationCatalog]
, c.COLLATION_SCHEMA [CollationSchema]
, c.COLLATION_NAME [CollationName]
, c.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, c.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, c.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsIdentity' ) as bit) as [IsIdentity]
, CAST(columnproperty( object_id(quotename(c.TABLE_SCHEMA) + '.' + quotename(c.TABLE_NAME)), c.COLUMN_NAME, 'IsComputed' ) | CASE WHEN c.DATA_TYPE = 'timestamp' THEN 1 ELSE 0 END as bit) as [IsStoreGenerated]
, c.COLUMN_DEFAULT [Default]
FROM
INFORMATION_SCHEMA.COLUMNS c
INNER JOIN
INFORMATION_SCHEMA.VIEWS v ON
c.TABLE_CATALOG = v.TABLE_CATALOG AND
c.TABLE_SCHEMA = v.TABLE_SCHEMA AND
c.TABLE_NAME = v.TABLE_NAME
WHERE
NOT (v.TABLE_SCHEMA = 'dbo'
AND v.TABLE_NAME in('syssegments', 'sysconstraints')
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
, CASE
WHEN DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
CHARACTER_MAXIMUM_LENGTH = -1 THEN
DATA_TYPE + '(max)'
ELSE
DATA_TYPE
END [ReturnTypeName]
, CHARACTER_MAXIMUM_LENGTH [ReturnMaxLength]
, CAST(NUMERIC_PRECISION as integer) [ReturnPrecision]
, CAST(DATETIME_PRECISION as integer) [ReturnDateTimePrecision]
, CAST(NUMERIC_SCALE as integer) [ReturnScale]
, COLLATION_CATALOG [ReturnCollationCatalog]
, COLLATION_SCHEMA [ReturnCollationSchema]
, COLLATION_NAME [ReturnCollationName]
, CHARACTER_SET_CATALOG [ReturnCharacterSetCatalog]
, CHARACTER_SET_SCHEMA [ReturnCharacterSetSchema]
, CHARACTER_SET_NAME [ReturnCharacterSetName]
, CAST(0 as bit) as [ReturnIsMultiSet]
, CAST(0 as bit) as [IsAggregate]
, CAST(0 as bit) as [IsBuiltIn]
, CAST(0 as bit) as [IsNiladic]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'FUNCTION'
SELECT
quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) + quotename(f.PARAMETER_NAME) [Id]
, quotename(f.SPECIFIC_SCHEMA) + quotename(f.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN f.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(f.PARAMETER_NAME, 2, LEN(f.PARAMETER_NAME) )
END [Name]
, f.ORDINAL_POSITION [Ordinal]
, CASE
WHEN f.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
f.CHARACTER_MAXIMUM_LENGTH = -1 THEN
f.DATA_TYPE + '(max)'
ELSE
f.DATA_TYPE
END [TypeName]
, f.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(f.NUMERIC_PRECISION as integer) [Precision]
, CAST(f.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(f.NUMERIC_SCALE as integer) [Scale]
, f.COLLATION_CATALOG [CollationCatalog]
, f.COLLATION_SCHEMA [CollationSchema]
, f.COLLATION_NAME [CollationName]
, f.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, f.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, f.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, f.PARAMETER_MODE [Mode]
, CAST(NULL as nvarchar(max)) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS f
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
f.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
f.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'FUNCTION'
WHERE
f.IS_RESULT = 'NO'
SELECT
quotename(SPECIFIC_SCHEMA) + quotename(SPECIFIC_NAME) [Id]
, SPECIFIC_CATALOG [CatalogName]
, SPECIFIC_SCHEMA [SchemaName]
, SPECIFIC_NAME [Name]
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
NOT (ROUTINE_SCHEMA = 'dbo'
AND ROUTINE_NAME LIKE 'dt[_]%'
AND SUBSTRING(CAST(SERVERPROPERTY('productversion') as varchar(20)),1,1) = 8)
AND (DATA_TYPE != 'TABLE' OR DATA_TYPE is null)
AND ROUTINE_TYPE = 'PROCEDURE'
SELECT
quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) + quotename(p.PARAMETER_NAME) [Id]
, quotename(p.SPECIFIC_SCHEMA) + quotename(p.SPECIFIC_NAME) [ParentId]
, CASE -- trim off the @ symbol
WHEN p.PARAMETER_NAME is null THEN NULL
ELSE SUBSTRING(p.PARAMETER_NAME, 2, LEN(p.PARAMETER_NAME) )
END [Name]
, p.ORDINAL_POSITION [Ordinal]
, CASE
WHEN p.DATA_TYPE in ('varchar', 'nvarchar', 'varbinary') and
p.CHARACTER_MAXIMUM_LENGTH = -1 THEN
p.DATA_TYPE + '(max)'
ELSE
p.DATA_TYPE
END [TypeName]
, p.CHARACTER_MAXIMUM_LENGTH [MaxLength]
, CAST(p.NUMERIC_PRECISION as integer) [Precision]
, CAST(p.DATETIME_PRECISION as integer) as [DateTimePrecision]
, CAST(p.NUMERIC_SCALE as integer) [Scale]
, p.COLLATION_CATALOG [CollationCatalog]
, p.COLLATION_SCHEMA [CollationSchema]
, p.COLLATION_NAME [CollationName]
, p.CHARACTER_SET_CATALOG [CharacterSetCatalog]
, p.CHARACTER_SET_SCHEMA [CharacterSetSchema]
, p.CHARACTER_SET_NAME [CharacterSetName]
, CAST(0 as bit) as [IsMultiSet]
, p.PARAMETER_MODE [Mode]
, CAST(NULL as nvarchar(max)) [Default]
FROM
INFORMATION_SCHEMA.PARAMETERS p
INNER JOIN INFORMATION_SCHEMA.ROUTINES r ON
p.SPECIFIC_SCHEMA = r.SPECIFIC_SCHEMA AND
p.SPECIFIC_NAME = r.SPECIFIC_NAME AND
r.ROUTINE_TYPE = 'PROCEDURE'
WHERE
p.IS_RESULT = 'NO'
SELECT
quotename(tc.CONSTRAINT_SCHEMA) + quotename(tc.CONSTRAINT_NAME) [Id]
, quotename(tc.TABLE_SCHEMA) + quotename(tc.TABLE_NAME) [ParentId]
, tc.CONSTRAINT_NAME [Name]
, tc.CONSTRAINT_TYPE [ConstraintType]
, CAST(CASE tc.IS_DEFERRABLE WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsDeferrable]
, CAST(CASE tc.INITIALLY_DEFERRED WHEN 'NO' THEN 0 ELSE 1 END as bit) [IsInitiallyDeferred]
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
WHERE tc.TABLE_NAME IS NOT NULL
SELECT
quotename(cc.CONSTRAINT_SCHEMA) + quotename(cc.CONSTRAINT_NAME) [Id]
, cc.CHECK_CLAUSE [Expression]
FROM
INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
SELECT
quotename(CONSTRAINT_SCHEMA) + quotename(CONSTRAINT_NAME) [ConstraintId]
, quotename(TABLE_SCHEMA) + quotename(TABLE_NAME) + quotename(COLUMN_NAME) [ColumnId]
FROM
INFORMATION_SCHEMA.KEY_COLUMN_USAGE
SELECT
quotename(rc.CONSTRAINT_SCHEMA) + quotename(rc.CONSTRAINT_NAME) [Id]
, CAST(rc.UPDATE_RULE as nvarchar(11)) [UpdateRule]
, CAST(rc.DELETE_RULE as nvarchar(11)) [DeleteRule]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc
SELECT
quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) + quotename(cast(FC.ORDINAL_POSITION as nvarchar(30))) [Id]
, quotename(PC.TABLE_SCHEMA) + quotename(PC.TABLE_NAME) + quotename(PC.COLUMN_NAME) [ToColumnId]
, quotename(FC.TABLE_SCHEMA) + quotename(FC.TABLE_NAME) + quotename(FC.COLUMN_NAME) [FromColumnId]
, quotename(FC.CONSTRAINT_SCHEMA) + quotename(FC.CONSTRAINT_NAME) [ConstraintId]
, FC.ORDINAL_POSITION [Ordinal]
FROM
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS PC /* PRIMARY KEY COLS*/
ON RC.UNIQUE_CONSTRAINT_SCHEMA = PC.CONSTRAINT_SCHEMA
AND RC.UNIQUE_CONSTRAINT_NAME = PC.CONSTRAINT_NAME
INNER JOIN
INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS FC /* FOREIGN KEY COLS*/
ON RC.CONSTRAINT_SCHEMA = FC.CONSTRAINT_SCHEMA
AND RC.CONSTRAINT_NAME = FC.CONSTRAINT_NAME
AND PC.ORDINAL_POSITION = FC.ORDINAL_POSITION
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(256)) [ParentId]
, CAST(NULL as nvarchar(256)) [Name]
, CAST(NULL as nvarchar(256)) [ConstraintType]
, CAST(0 as bit) [IsDeferrable]
, CAST(0 as bit) [IsInitiallyDeferred]
, CAST(NULL as nvarchar(max)) [Expression]
, CAST(NULL as nvarchar(11)) [UpdateRule]
, CAST(NULL as nvarchar(11)) [DeleteRule]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [ConstraintId]
, CAST(NULL as nvarchar(max)) [ColumnId]
WHERE 1=2
SELECT
CAST(NULL as nvarchar(1)) [Id]
, CAST(NULL as nvarchar(max)) [ToColumnId]
, CAST(NULL as nvarchar(max)) [FromColumnId]
, CAST(NULL as nvarchar(1)) [ConstraintId]
, 0 [Ordinal]
WHERE 1=2
ð4 
ø0 
Ù
Ð
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
œM
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
ÏM
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
M
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
îÕ
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
This type allows pretty much any content
¿n
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
This type allows pretty much any content
]P
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
This type allows pretty much any content
O
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
The Documentation element is used to provide documentation of comments on the contents of the XML file. It is valid under Schema, Type, Index and Relationship elements.
This type allows pretty much any content
“
%D
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
—E
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
@B
Common Data Model Schema Definition Language.
Copyright (c) Microsoft Corp. All rights reserved.
o
°2 ÎÊï¾ ‘ lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet › PADPADPîî€U€® €H7€Æ.€70€¤`€æ×q€ú—‚€‡¸¥€¡C¦€@·€šÌ€¹ñÌ€Y6�D³ �•8�®ÀV��Ha�u_m�˜ô�e£‚Qè7‚¥�I‚ª$R‚”Î[‚J-„‚âªÁ‚+·ø‚^Š"ƒX¨öƒ¦s\„U±]„2š„} ¥„ë΄fó„
Ÿ/…\õ8…¦
�…úà‘…b¡Â…që2†3èN†b°l†=óõ–†ÙB›†\Þ©†ýµC‡kZO‡§ðP‡×Û[‡: ^‡{¾g‡�Qh‡Öéu‡*ó±‡S½‡»xЇFôî‡gõˆtÂ7ˆ…)Dˆ'Ãrˆ»"¼ˆe´þˆy„‰½hµ‰ŠGçŠ;-ŠÓG2Š<5ЏòcŠ3‡Š´Q•ŠêŸŠ¨‹©í ‹qW‹ee‹Zo‹[+v‹Q"»‹9Œñ‹Y ô‹„ˆŒŽ
ŒV@hŒ
tŒ.v…ŒN1ÆŒÄÈ׌ òŒG �×Pœ�Ľä�îø�Ÿv1ŽŠuŽŽdúò޵�Mad�Gb}�P.œ�G�Û"Ü�IB�ú���–�Câ›�DI¢�GUã�vÂõ�„f‘ûð‹‘j%�‘b…¶‘ơ‘©«Ä‘U[Ì‘ÜnΑ_Þò‘å’sß’å+;’k�’¶g¼’nÂ
“ b;“œoW“�+u“Gxù“ .”{_” 2g”¶"i”×cm”°/·”^Ãà”³æ5•“ý”•!Ò–•LSê•NÇ –‚e?–Ûœ?–³Q[–$Y\–cÈ–Žb—7K˜—e¼—+Å—µØ-˜å9˜ƒÕ‘˜°Õ˜}…*™×Ï_™WºÎ™ôwÑ™=mð™]„Ušêÿ™š»žšš[ÒšGØš«qØš3kïšWþ%›»4›ÚÐ7›Ÿü¢›óÿ›óf-œ
w�œEÝžœCö¨œ×±œÀ
·œ±%Ïœ P휪r/� c�
ÎÐ�Qmî�Ó<ö�ó>ú�‹dú�›2ž’…žšŸE(*Ÿñ:Ÿé®BŸæÛnŸÅ‘…ŸTËŸªÿÔŸ[JñŸc
^ Â:ì 9½¡ZQ&¡øX™¡†Â¡&¢µ¢£f)¢•/¢”V¢ás¢&Õ·¢¸Ë¢�ÃË¢¡ÜË¢[
Ì¢ˆ)Ì¢»ã¢ Êê¢,ãÐó2£tO:£\££V_±£H7ú£×ÕW¤>Å¿¤°"á¤U{ñ¤-vM¥äd‘¥éö÷¥^ãZ¦©m…¦@�¦Õà¦sꦟD§0»G§ZÍ®§Àܳ§ô
¨•‡M¨—�o¨Í�„¨$W‹¨HÞÚ¨&"©áO©Û¹Y©å;d©C覩ˆ¨Õ©ñRª=Gªõoߪҫ±Ž%«¹â«” ¬;ÃS¬KÀˆ¬õŽ�¬#ǧ¬to48Œp<²·±eã*®Lí3®õ‘�®ÏG5¯ã5_¯&’d¯LÒk¯¶™z¯o2ܯgp°ÓÄ-°rE°Ê†”°–¿°·Ô°Gx±âçL±ÇrT±7¦g±'[i±½q±½ž4²
ÐW²„)βrÞ³K‚ ´c D´‡ã€´Çd¾´þâÄ´—ðï´ã— µj8
µKX*µ6ž/µŸÙCµ¿]µÅ³€µèz‡µË“µ1ŸÉµr=¶:J¶tBZ¶†¨a¶ÌQl¶å`–¶LßÓ¶ÎÒ_·xJo·›Ó·†+Ü·Õ›è·X$û·¬F¸äí�¸ÿ*�¸°Å¹é'-¹99?¹À®¹û~ê¹IRºsJžº³Í»×,»
‰»—»N—Ñ»ÖÕÓ»P¸z¼†’¼$¢²¼þFþ¼g;1½Û&C½-ôT½ oW½Ãf½½ï˜¾)Ϋ¾:«Â¾”ÇɾtçÓ¾Q;¿Ùhµ¿
†¾¿¶‰Ë¿…ë¿~sþ¿æ=À¶T=À(nNÀ»«[ÀÏByÀ‡ŒÀ¸ü¡Àà�£À¦N¤ÀøoÖÀ½ƒÞÀ
†ãÀ|úXÁÚ@ÄÁè/ÊÁšcÐÁzíàÁ·ëöÁª¼Â×5@Â;€ÂYħÂ8Ó¼ØÂëÃ2ø;à ,MÃ\8pȉÃîi¹ÃÕ”Ä)wÂÄyÞÄãÅÅ6˜AÅÖÕQÅJéœÅÁº¶ÅñÌËÅIŒøÅkF;Æ ^`Æ|7°Æ ÝÆ•òÆGH„ÇEm†Ç¸¨Ç‰ø²ÇfÆÇŠËÇZŠðÇ@Ô
Èz‚È1gÈ¢ñ:ÈqÝTÈCâ£ÈñÉ;cÉmº}ɸڣÉÑyÌÉ9*ÊACGÊ®v¹ÊغÊYs»Ê�hËv^Ëž…0ËÒ¡JËîbˤd†Ë˜q†ËÈD±ËÌ
ÄË„ÕË)Ì9�w̵õ®Ìz�çÌeÞûÌòÚÍÔ"6ÍÍ>ÍO
VÍëÎÞ¼Îãîδ…ÏÚ4Ï*½ÏwЯ.Ð"WÐÎ&wÐQûæÐBºÑ`ÃÑ_ƒôÑx1$Ò{1$Ò°®*ÒRØYÒ)ðÿÒaÂÓÝ#øÓÜeÔ\[$ÕVÃ(Õ‡”)Õ›8Õ‹²ªÕb¶ Ö…:ÖbžYÖDJ~ÖˆÖÖŸ ÖÐLÏÖCó
×Î×`(×5ó<׬˜¦×maÒ×[ÎÙ×Ðeì×ç`ú×”EØ£ÎØérÙQ1ÙTPSÙ(ArÙ‚»±ÙâöÏÙÄøÙÞ8ÚæàÚkÚ:™<ÚÆCÚ�÷QÚKð¼Ú’ÐÚöÈ,ÛñÜGÛÛMÛÑ}PÛ´ RÛóMSÛW�TÛCÊnÛ¯ý¬ÛÕi¹Û#ý½Ûu1Eܰ³NÜ’m—ÜÄ–‡Ýç'ÁÝ0¥ôÝ<›Þ›D¤ÞëÖ¦Þ]ê§ÞØßspƒß¥ýßôÞß>lþß1Wàê&àaHà }àÞ‡ à”‰+àžéHà´—àøà¤=árFDáÉÅVá<&…á–‡á-jÂáÕÔÏá¬ÒVâ[â1_â�i_âlô¥âѶâ×”Ìâ“æñâ�'@ãÁ¢-ä™äQäÞ]uäîÞ�侸òätY�勿ÔåA¸Ûå,‡]æb÷Ùæ%! çð…[ç ÊŠçÛcÇç)-ãçÒïçcÍ èʪèÁºWè¹YcèŠ'Áèr[ÔèmàèùÂ"éö³Oé8ïaé¨Ãté«Ãt逻Ñé7)[êÎÁê}.ˆê¶�ÎêȃJë³þkë#Œ¦ë¶©ëÏ’¼ë¢Dãë6eöëÒ5)ìX˜Åì×9áìá“
íDípÒ.í‚è8í•ÖËí
3î)(
îÝë
î‚O!î�6îVTîë jî™Poî&Ÿîѵ°î pµîdSþî¥ßYgï}`¶ï KÕïÕ6õïŽð
'EðRvxð9™€ðw5žðÎß¿ð9�ñ‘®=ñ™§bñÓâŽñ+—“ñÈÀ�ñQo®ñŠ/úñ‘,òƒ
2òýeFò½–rò¯˜ròƒ|Ðòt)øòEäó'Ü!óD,óóÚ-óì7ób7@óER¨óÿIó(¥³óD#Wô9áuôºñõ ñ[õ9®žõùÍõÖìåõgIöJà2öû®Êö;Aåöj*ìöHpíö]?÷>ó}øy_Éø™©Óø¾·âøãKãùûÉúNß2úôÀ<úµÜ>úÃ9Lú¼júÉœ±ú{qÔú~É×ú>êàú&ë4ûŒÃAû rûA?ü9mCü!
FüˆHüˆHü°ÑPüf.¶ü¼ý\²5ý%ÄOý‘—ƒý®å¡ýΦÕý Øý¸øýã|þñE1þãLþ:~œþíY÷þÖîÿþ¹Zÿ¾jÿ!pÿ�õ¬ÿ…ÏÙÿ×Ó: ÀuK Ø{ Ѫ žû ¬?�šfÑw¼j‡ð‹‡®¶�ÈR`Ì¸ØØYÞªªðñJ]†g;®ÁJZÂ]RÔnêðX
«x—:‘ó>ê€T'Zz
É}�Jˆ"hšyš¸w©ç±}|=6Ð?‹³€ŽÊQ©á�ÁãYÎ.ºè^$�#Sù1ˆS0'£.“Ã4ÓGSõY
ÁÔSÁV®;‡UöQ9òXH`»,uå�ÊŽaí:= Áa ñ=d ë²| ¥Qž z Ï ÚöÝ ~&