How to know the query which I wrote of some sql table in my SQL database.

Question

I need the actual statement which I wrote unfortunately it is not visible to me but I can use the table...I want to view the statement

Answer 1

I don't understand what you ask here. Actual statement? what statement? why it is not visible?

I suggest you to edit the thread to be more descriptive. Otherwise it is unlikely for you to get an effective respond.

Answer 2

my doubt is when I use my database by command Use "name of database"....so what I need here is the Syntex of the schemas which I defined earlier in this database........I simply want to retrieve the statements that I wrote....is it possible???

Answer 3

So, if you type 'use <database-name>;' you want to get that command back. Is this what you mean?. Cause at the moment I still am not getting what you actually want.

Someone else would see this and help later on. I'm not getting any idea : )

Answer 4

let's clear..............if I made a table name EMP...like create tablenemp(name varchar,age int );SO I WANT THESE COMMANDS BACK...