Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images
Bewarse Talk Discussion Board * Archives - 2015 * Cine Talk - Reviews, Gossips, Insider Info etc. * Archive through September 29, 2015 * Calling SQLServer Bedars! < Previous Next >

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this 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:    Edit Post Delete Post Print Post


Mrbezawada:




taanksee bez annai


Siloan:

management studio nunchi dimpaleva ?




ee jaffa gaallu andariki install sesi savala studio, evo open source client meeda nettukostunna
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

management studio nunchi dimpaleva ?
Top of pagePrevious messageNext messageBottom of page Link to this message

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:    Edit Post Delete Post Print Post

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. MOVIEART--jp.alage

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration