| Author |
Message |
    
Blazewada
Mudiripoyina Bewarse
Username: Blazewada
Post Number: 24252
Registered: 08-2008
Posted From: 119.56.122.195
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, September 28, 2015 - 8:58 pm: |
|
Mrbezawada:
taanksee bez annai
Siloan:management studio nunchi dimpaleva ?
ee jaffa gaallu andariki install sesi savala studio, evo open source client meeda nettukostunna |
Mrbezawada
Pilla Bewarse
Username: Mrbezawada
Post Number: 89
Registered: 10-2011
Posted From: 205.172.134.23
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, September 28, 2015 - 4:13 pm: |
|
Blaze Annay, I dont have any script. But I created one for you. Check this and let me know:
CREARE PROCEDURE MyDatabase.dboTABLE_INFO(@DatabaseName NVARCHAR(20))
AS
BEGIN
DECLARE @SQL NVARCHAR(1000);
SET @SQL = 'USE '+@DatabaseName ;
SET @SQL = @SQL + CHAR(13);
SET @SQL = @SQL + '
SELECT OBJECT_NAME(parent_object_id) AS TABLE_NAME
, type_desc AS CONSTRAINT_TYPE
, OBJECT_NAME(OBJECT_ID) AS NAME_OF_CONSTRAINT
FROM sys.objects
WHERE type_desc LIKE '''+'%CONSTRAINT%''
ORDER BY OBJECT_NAME(parent_object_id), type_desc
SELECT Tab.name AS TABLE_NAME, Ind.name AS Index_Name
FROM sys.[indexes] Ind
INNER JOIN sys.[tables] AS Tab
ON Tab.[object_id] = Ind.[object_id]
WHERE Ind.name IS NOT NULL '
EXECUTE sp_executesql @SQL;
END
EXEC MyDatabase.dboTABLE_INFO 'MyDataBase'
Bezawada Bewarse Batchey
|
Siloan
Pilla Bewarse
Username: Siloan
Post Number: 942
Registered: 09-2008
Posted From: 132.174.20.41
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, September 28, 2015 - 2:30 pm: |
|
management studio nunchi dimpaleva ? |
Blazewada
Mudiripoyina Bewarse
Username: Blazewada
Post Number: 24244
Registered: 08-2008
Posted From: 119.56.123.65
Rating: N/A
Votes: 0 (Vote!) | | Posted on Monday, September 28, 2015 - 6:57 am: |
|
need a procedure to generate report with tables along with associated constraints and indexes. grouped by table name. unique constraints oka gumpu, notnull constraints okaa gumpu, primary key constraint per table kinda report kavali.
gooogle lo sava lacha ochai but meeru etanna ivagaligithe meeru vadedi use aithadi.  |
Archives - 2015